diff options
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 00000000000..f0176a06166 --- /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}'; + |