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