/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/btree_gist/sql/cidr.sql
30 строк
800 B
Tom Lane
Create btree_gist v1.9, in which inet/cidr opclasses aren't default.
08 янв 2026, 21:56
08 янв 2026, 21:56
b3b0b45
Код
Авторство
О чём код?
-- cidr check CREATE TABLE cidrtmp AS SELECT cidr(a) AS a FROM inettmp ; SET enable_seqscan=on; SELECT count(*) FROM cidrtmp WHERE a < '121.111.63.82'; SELECT count(*) FROM cidrtmp WHERE a <= '121.111.63.82'; SELECT count(*) FROM cidrtmp WHERE a = '121.111.63.82'; SELECT count(*) FROM cidrtmp WHERE a >= '121.111.63.82'; SELECT count(*) FROM cidrtmp WHERE a > '121.111.63.82'; CREATE INDEX cidridx ON cidrtmp USING gist ( a gist_cidr_ops ); SET enable_seqscan=off; SELECT count(*) FROM cidrtmp WHERE a < '121.111.63.82'::cidr; SELECT count(*) FROM cidrtmp WHERE a <= '121.111.63.82'::cidr; SELECT count(*) FROM cidrtmp WHERE a = '121.111.63.82'::cidr; SELECT count(*) FROM cidrtmp WHERE a >= '121.111.63.82'::cidr; SELECT count(*) FROM cidrtmp WHERE a > '121.111.63.82'::cidr;