diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-03-17 21:59:42 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-03-17 21:59:42 +0000 |
| commit | 4bcb80a3e3112fb5969c3fbabaa5ecd3bd95f997 (patch) | |
| tree | 2c85bed26cf4414c286051dac5bb9b4c6889c04d /contrib/intarray/sql | |
| parent | 5a38af7fd8346cd9209c4a66754a4e653d88db57 (diff) | |
| download | postgresql-4bcb80a3e3112fb5969c3fbabaa5ecd3bd95f997.tar.gz | |
Update contrib intarray to Jan 25 version.
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 f0176a0616..b23d406a6a 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}'; + |