1-- cidr check 2 3CREATE TABLE cidrtmp AS 4 SELECT cidr(a) AS a FROM inettmp ; 5 6SET enable_seqscan=on; 7 8SELECT count(*) FROM cidrtmp WHERE a < '121.111.63.82'; 9 10SELECT count(*) FROM cidrtmp WHERE a <= '121.111.63.82'; 11 12SELECT count(*) FROM cidrtmp WHERE a = '121.111.63.82'; 13 14SELECT count(*) FROM cidrtmp WHERE a >= '121.111.63.82'; 15 16SELECT count(*) FROM cidrtmp WHERE a > '121.111.63.82'; 17 18CREATE INDEX cidridx ON cidrtmp USING gist ( a ); 19 20SET enable_seqscan=off; 21 22SELECT count(*) FROM cidrtmp WHERE a < '121.111.63.82'::cidr; 23 24SELECT count(*) FROM cidrtmp WHERE a <= '121.111.63.82'::cidr; 25 26SELECT count(*) FROM cidrtmp WHERE a = '121.111.63.82'::cidr; 27 28SELECT count(*) FROM cidrtmp WHERE a >= '121.111.63.82'::cidr; 29 30SELECT count(*) FROM cidrtmp WHERE a > '121.111.63.82'::cidr; 31