diff options
Diffstat (limited to 'contrib/intarray/sql')
| -rw-r--r-- | contrib/intarray/sql/_int.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/contrib/intarray/sql/_int.sql b/contrib/intarray/sql/_int.sql index f0176a06166..b23d406a6ab 100644 --- a/contrib/intarray/sql/_int.sql +++ b/contrib/intarray/sql/_int.sql @@ -13,3 +13,14 @@ CREATE TABLE test__int( a int[] ); SELECT count(*) from test__int WHERE a && '{23,50}'; SELECT count(*) from test__int WHERE a @ '{23,50}'; +CREATE INDEX text_idx on test__int using gist ( a gist__int_ops ) with ( islossy ); + +SELECT count(*) from test__int WHERE a && '{23,50}'; +SELECT count(*) from test__int WHERE a @ '{23,50}'; + +drop index text_idx; +CREATE INDEX text_idx on test__int using gist ( a gist__intbig_ops ) with ( islossy ); + +SELECT count(*) from test__int WHERE a && '{23,50}'; +SELECT count(*) from test__int WHERE a @ '{23,50}'; + |