/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gin/sql/int4.sql
33 строки
1 KB
Tom Lane
Add cross-type comparisons to contrib/btree_gin.
03 июл 2025, 23:24
03 июл 2025, 23:24
e2b64fc
Код
Авторство
О чём код?
set enable_seqscan=off; CREATE TABLE test_int4 ( i int4 ); INSERT INTO test_int4 VALUES (-2),(-1),(0),(1),(2),(3); CREATE INDEX idx_int4 ON test_int4 USING gin (i); SELECT * FROM test_int4 WHERE i<1::int4 ORDER BY i; SELECT * FROM test_int4 WHERE i<=1::int4 ORDER BY i; SELECT * FROM test_int4 WHERE i=1::int4 ORDER BY i; SELECT * FROM test_int4 WHERE i>=1::int4 ORDER BY i; SELECT * FROM test_int4 WHERE i>1::int4 ORDER BY i; explain (costs off) SELECT * FROM test_int4 WHERE i<1::int2 ORDER BY i; SELECT * FROM test_int4 WHERE i<1::int2 ORDER BY i; SELECT * FROM test_int4 WHERE i<=1::int2 ORDER BY i; SELECT * FROM test_int4 WHERE i=1::int2 ORDER BY i; SELECT * FROM test_int4 WHERE i>=1::int2 ORDER BY i; SELECT * FROM test_int4 WHERE i>1::int2 ORDER BY i; explain (costs off) SELECT * FROM test_int4 WHERE i<1::int8 ORDER BY i; SELECT * FROM test_int4 WHERE i<1::int8 ORDER BY i; SELECT * FROM test_int4 WHERE i<=1::int8 ORDER BY i; SELECT * FROM test_int4 WHERE i=1::int8 ORDER BY i; SELECT * FROM test_int4 WHERE i>=1::int8 ORDER BY i; SELECT * FROM test_int4 WHERE i>1::int8 ORDER BY i;