/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gin/sql/bpchar.sql
22 строки
901 B
Teodor Sigaev
Add support of bool, bpchar, name and uuid to btree_gin
05 апр 2018, 18:19
05 апр 2018, 18:19
f4cd710
Код
Авторство
О чём код?
set enable_seqscan=off; CREATE TABLE test_bpchar ( i char(10) ); INSERT INTO test_bpchar VALUES ('a'),('ab'),('abc'),('abc '),('abb'),('axy'),('xyz'),('xyz '); CREATE INDEX idx_bpchar ON test_bpchar USING gin (i); SELECT * FROM test_bpchar WHERE i<'abc' ORDER BY i; SELECT * FROM test_bpchar WHERE i<='abc' ORDER BY i; SELECT * FROM test_bpchar WHERE i='abc' ORDER BY i; SELECT * FROM test_bpchar WHERE i='abc ' ORDER BY i; SELECT * FROM test_bpchar WHERE i>='abc' ORDER BY i; SELECT * FROM test_bpchar WHERE i>'abc' ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i<'abc' ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i<='abc' ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i='abc' ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i>='abc' ORDER BY i; EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i>'abc' ORDER BY i;