diff options
| author | Bruce Momjian | 2001-03-17 21:59:42 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2001-03-17 21:59:42 +0000 |
| commit | 4bcb80a3e3112fb5969c3fbabaa5ecd3bd95f997 (patch) | |
| tree | 2c85bed26cf4414c286051dac5bb9b4c6889c04d /contrib/intarray/expected | |
| parent | 5a38af7fd8346cd9209c4a66754a4e653d88db57 (diff) | |
Update contrib intarray to Jan 25 version.
Diffstat (limited to 'contrib/intarray/expected')
| -rw-r--r-- | contrib/intarray/expected/_int.out | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/contrib/intarray/expected/_int.out b/contrib/intarray/expected/_int.out index b38102aa051..62748cefaf2 100644 --- a/contrib/intarray/expected/_int.out +++ b/contrib/intarray/expected/_int.out @@ -17,3 +17,30 @@ SELECT count(*) from test__int WHERE a @ '{23,50}'; 12 (1 row) +CREATE INDEX text_idx on test__int using gist ( a gist__int_ops ) with ( islossy ); +SELECT count(*) from test__int WHERE a && '{23,50}'; + count +------- + 345 +(1 row) + +SELECT count(*) from test__int WHERE a @ '{23,50}'; + count +------- + 12 +(1 row) + +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}'; + count +------- + 345 +(1 row) + +SELECT count(*) from test__int WHERE a @ '{23,50}'; + count +------- + 12 +(1 row) + |