diff options
| author | Bruce Momjian | 2001-09-23 04:16:16 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2001-09-23 04:16:16 +0000 |
| commit | 484a0fa45480957222759bbeb541cc2eb6226963 (patch) | |
| tree | 601fec446c75692c762fb3aebb99b8153865d8fc /contrib/intarray/sql | |
| parent | 296011d87e9997fe9acd2a76bd2efaca469fc7d2 (diff) | |
please apply attached patch to current CVS.
Changes:
1. Added support for boolean queries (indexable operator @@, looks like
a @@ '1|(2&3)'
2. Some code cleanup and optimization
Regards,
Oleg
Diffstat (limited to 'contrib/intarray/sql')
| -rw-r--r-- | contrib/intarray/sql/_int.sql | 58 |
1 files changed, 58 insertions, 0 deletions
diff --git a/contrib/intarray/sql/_int.sql b/contrib/intarray/sql/_int.sql index 9635c5f26fe..52313ef7a17 100644 --- a/contrib/intarray/sql/_int.sql +++ b/contrib/intarray/sql/_int.sql @@ -6,21 +6,79 @@ \i _int.sql \set ECHO all +--test query_int +select '1'::query_int; +select ' 1'::query_int; +select '1 '::query_int; +select ' 1 '::query_int; +select ' ! 1 '::query_int; +select '!1'::query_int; +select '1|2'::query_int; +select '1|!2'::query_int; +select '!1|2'::query_int; +select '!1|!2'::query_int; +select '!(!1|!2)'::query_int; +select '!(!1|2)'::query_int; +select '!(1|!2)'::query_int; +select '!(1|2)'::query_int; +select '1&2'::query_int; +select '!1&2'::query_int; +select '1&!2'::query_int; +select '!1&!2'::query_int; +select '(1&2)'::query_int; +select '1&(2)'::query_int; +select '!(1)&2'::query_int; +select '!(1&2)'::query_int; +select '1|2&3'::query_int; +select '1|(2&3)'::query_int; +select '(1|2)&3'::query_int; +select '1|2&!3'::query_int; +select '1|!2&3'::query_int; +select '!1|2&3'::query_int; +select '!1|(2&3)'::query_int; +select '!(1|2)&3'::query_int; +select '(!1|2)&3'::query_int; +select '1|(2|(4|(5|6)))'::query_int; +select '1|2|4|5|6'::query_int; +select '1&(2&(4&(5&6)))'::query_int; +select '1&2&4&5&6'::query_int; +select '1&(2&(4&(5|6)))'::query_int; +select '1&(2&(4&(5|!6)))'::query_int; + + CREATE TABLE test__int( a int[] ); \copy test__int from 'data/test__int.data' 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)'; CREATE INDEX text_idx on test__int using gist ( a gist__int_ops ); 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)'; drop index text_idx; CREATE INDEX text_idx on test__int using gist ( a gist__intbig_ops ); 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)'; |