aboutsummaryrefslogtreecommitdiff
path: root/contrib/intarray/sql/_int.sql
blob: f0176a06166911ac143bb4690f145a0e1f900c67 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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}';