← Back to branch summary

~vcs-imports/mammoth-replicator/trunk

« back to all changes in this revision

Viewing changes to contrib/btree_gist/sql/cidr.sql

  • Committer: alvherre
  • Date: 2005-12-16 21:24:52 UTC
  • Revision ID: svn-v4:db760fc0-0f08-0410-9d63-cc6633f64896:trunk:1
Initial import of the REL8_0_3 sources from the Pgsql CVS repository.

Show diffs side-by-side

added added

removed removed

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