PolarDB-for-PostgreSQL

1
set enable_seqscan=off;
2

3
CREATE TABLE test_text (
4
	i text
5
);
6

7
INSERT INTO test_text VALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz');
8

9
CREATE INDEX idx_text ON test_text USING gin (i);
10

11
SELECT * FROM test_text WHERE i<'abc' ORDER BY i;
12
SELECT * FROM test_text WHERE i<='abc' ORDER BY i;
13
SELECT * FROM test_text WHERE i='abc' ORDER BY i;
14
SELECT * FROM test_text WHERE i>='abc' ORDER BY i;
15
SELECT * FROM test_text WHERE i>'abc' ORDER BY i;
16