diff options
author | Marc G. Fournier <scrappy@hub.org> | 2001-01-12 00:16:26 +0000 |
---|---|---|
committer | Marc G. Fournier <scrappy@hub.org> | 2001-01-12 00:16:26 +0000 |
commit | 1db943b3ca5a8f405155c904964272ce52d96f00 (patch) | |
tree | ce6698a8870469f2468899e2ef79596b8a3df5dd /contrib/intarray/sql | |
parent | 0ad7db4be4b1f0208271c49fc1c8348f11ebc5b3 (diff) | |
download | postgresql-1db943b3ca5a8f405155c904964272ce52d96f00.tar.gz |
commit Oleg and Teodor's RD-tree implementation ... this provides the
regression tests for the GiST changes ... this should be integrated into
the regular regression tests similar to Vadim's SPI contrib stuff ...
Diffstat (limited to 'contrib/intarray/sql')
-rw-r--r-- | contrib/intarray/sql/_int.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/contrib/intarray/sql/_int.sql b/contrib/intarray/sql/_int.sql new file mode 100644 index 0000000000..f0176a0616 --- /dev/null +++ b/contrib/intarray/sql/_int.sql @@ -0,0 +1,15 @@ +-- +-- first, define the datatype. Turn off echoing so that expected file +-- does not depend on contents of seg.sql. +-- +\set ECHO none +\i _int.sql +\set ECHO all + +CREATE TABLE test__int( a int[] ); + +\copy test__int from 'data/test__int.data' + +SELECT count(*) from test__int WHERE a && '{23,50}'; +SELECT count(*) from test__int WHERE a @ '{23,50}'; + |