/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gist/sql/bool.sql
42 строки
888 B
Tomas Vondra
Add bool GiST opclass to btree_gist
06 ноя 2021, 19:00
06 ноя 2021, 19:00
57e3c51
Код
Авторство
О чём код?
-- bool check CREATE TABLE booltmp (a bool); INSERT INTO booltmp VALUES (false), (true); SET enable_seqscan=on; SELECT count(*) FROM booltmp WHERE a < true; SELECT count(*) FROM booltmp WHERE a <= true; SELECT count(*) FROM booltmp WHERE a = true; SELECT count(*) FROM booltmp WHERE a >= true; SELECT count(*) FROM booltmp WHERE a > true; CREATE INDEX boolidx ON booltmp USING gist ( a ); SET enable_seqscan=off; SELECT count(*) FROM booltmp WHERE a < true; SELECT count(*) FROM booltmp WHERE a <= true; SELECT count(*) FROM booltmp WHERE a = true; SELECT count(*) FROM booltmp WHERE a >= true; SELECT count(*) FROM booltmp WHERE a > true; -- Test index-only scans SET enable_bitmapscan=off; EXPLAIN (COSTS OFF) SELECT * FROM booltmp WHERE a; SELECT * FROM booltmp WHERE a; EXPLAIN (COSTS OFF) SELECT * FROM booltmp WHERE NOT a; SELECT * FROM booltmp WHERE NOT a;