diff options
| author | Teodor Sigaev | 2006-05-03 16:31:07 +0000 |
|---|---|---|
| committer | Teodor Sigaev | 2006-05-03 16:31:07 +0000 |
| commit | 5320c6cf6b21811eda1910a7df6f05b992fe2aea (patch) | |
| tree | 0d1c7aa43268011628a08e8f7a182c5bad20de3d /contrib/intarray/expected | |
| parent | 2a58f3bff6ff9abda33af0ed117f068ee02d6c83 (diff) | |
Make GIN opclass worked with intarray extensions
Diffstat (limited to 'contrib/intarray/expected')
| -rw-r--r-- | contrib/intarray/expected/_int.out | 58 |
1 files changed, 54 insertions, 4 deletions
diff --git a/contrib/intarray/expected/_int.out b/contrib/intarray/expected/_int.out index 85c8d8bb14..e45ed3cfa8 100644 --- a/contrib/intarray/expected/_int.out +++ b/contrib/intarray/expected/_int.out @@ -3,12 +3,12 @@ -- does not depend on contents of _int.sql. -- \set ECHO none -psql:_int.sql:13: NOTICE: type "query_int" is not yet defined +psql:_int.sql:15: NOTICE: type "query_int" is not yet defined DETAIL: Creating a shell type definition. -psql:_int.sql:18: NOTICE: argument type query_int is only a shell -psql:_int.sql:368: NOTICE: type "intbig_gkey" is not yet defined +psql:_int.sql:20: NOTICE: argument type query_int is only a shell +psql:_int.sql:370: NOTICE: type "intbig_gkey" is not yet defined DETAIL: Creating a shell type definition. -psql:_int.sql:373: NOTICE: argument type intbig_gkey is only a shell +psql:_int.sql:375: NOTICE: argument type intbig_gkey is only a shell SELECT intset(1234); intset -------- @@ -519,3 +519,53 @@ SELECT count(*) from test__int WHERE a @@ '(20&23)|(50&68)'; 21 (1 row) +DROP INDEX text_idx; +CREATE INDEX text_idx on test__int using gin ( a ); +SELECT count(*) from test__int WHERE a && '{23,50}'; + count +------- + 403 +(1 row) + +SELECT count(*) from test__int WHERE a @@ '23|50'; + count +------- + 403 +(1 row) + +SELECT count(*) from test__int WHERE a @ '{23,50}'; + count +------- + 12 +(1 row) + +SELECT count(*) from test__int WHERE a @@ '23&50'; + count +------- + 12 +(1 row) + +SELECT count(*) from test__int WHERE a @ '{20,23}'; + count +------- + 12 +(1 row) + +SELECT count(*) from test__int WHERE a @@ '50&68'; + count +------- + 9 +(1 row) + +SELECT count(*) from test__int WHERE a @ '{20,23}' or a @ '{50,68}'; + count +------- + 21 +(1 row) + +SELECT count(*) from test__int WHERE a @@ '(20&23)|(50&68)'; + count +------- + 21 +(1 row) + |