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/sql | |
| parent | 2a58f3bff6ff9abda33af0ed117f068ee02d6c83 (diff) | |
Make GIN opclass worked with intarray extensions
Diffstat (limited to 'contrib/intarray/sql')
| -rw-r--r-- | contrib/intarray/sql/_int.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/contrib/intarray/sql/_int.sql b/contrib/intarray/sql/_int.sql index 5c0d00c67ab..e04b88e7512 100644 --- a/contrib/intarray/sql/_int.sql +++ b/contrib/intarray/sql/_int.sql @@ -107,3 +107,15 @@ SELECT count(*) from test__int WHERE a @ '{20,23}'; SELECT count(*) from test__int WHERE a @@ '50&68'; SELECT count(*) from test__int WHERE a @ '{20,23}' or a @ '{50,68}'; SELECT count(*) from test__int WHERE a @@ '(20&23)|(50&68)'; + +DROP INDEX text_idx; +CREATE INDEX text_idx on test__int using gin ( a ); + +SELECT count(*) from test__int WHERE a && '{23,50}'; +SELECT count(*) from test__int WHERE a @@ '23|50'; +SELECT count(*) from test__int WHERE a @ '{23,50}'; +SELECT count(*) from test__int WHERE a @@ '23&50'; +SELECT count(*) from test__int WHERE a @ '{20,23}'; +SELECT count(*) from test__int WHERE a @@ '50&68'; +SELECT count(*) from test__int WHERE a @ '{20,23}' or a @ '{50,68}'; +SELECT count(*) from test__int WHERE a @@ '(20&23)|(50&68)'; |