2 -- first, define the datatype. Turn off echoing so that expected file
3 -- does not depend on contents of seg.sql.
6 CREATE TABLE test__int( a int[] );
7 \copy test__int from 'data/test__int.data'
8 SELECT count(*) from test__int WHERE a && '{23,50}';
14 SELECT count(*) from test__int WHERE a @ '{23,50}';
20 CREATE INDEX text_idx on test__int using gist ( a gist__int_ops ) with ( islossy );
21 SELECT count(*) from test__int WHERE a && '{23,50}';
27 SELECT count(*) from test__int WHERE a @ '{23,50}';
34 CREATE INDEX text_idx on test__int using gist ( a gist__intbig_ops ) with ( islossy );
35 SELECT count(*) from test__int WHERE a && '{23,50}';
41 SELECT count(*) from test__int WHERE a @ '{23,50}';