diff options
Diffstat (limited to 'contrib/btree_gist/sql/bit.sql')
| -rw-r--r-- | contrib/btree_gist/sql/bit.sql | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/bit.sql b/contrib/btree_gist/sql/bit.sql new file mode 100644 index 00000000000..a6b6ab3b3b7 --- /dev/null +++ b/contrib/btree_gist/sql/bit.sql @@ -0,0 +1,31 @@ +-- bit check + +CREATE TABLE bittmp (a bit(33)); + +\copy bittmp from 'data/bit.data' + +SET enable_seqscan=on; + +SELECT count(*) FROM bittmp WHERE a < '011011000100010111011000110000100'; + +SELECT count(*) FROM bittmp WHERE a <= '011011000100010111011000110000100'; + +SELECT count(*) FROM bittmp WHERE a = '011011000100010111011000110000100'; + +SELECT count(*) FROM bittmp WHERE a >= '011011000100010111011000110000100'; + +SELECT count(*) FROM bittmp WHERE a > '011011000100010111011000110000100'; + +CREATE INDEX bitidx ON bittmp USING GIST ( a ); + +SET enable_seqscan=off; + +SELECT count(*) FROM bittmp WHERE a < '011011000100010111011000110000100'; + +SELECT count(*) FROM bittmp WHERE a <= '011011000100010111011000110000100'; + +SELECT count(*) FROM bittmp WHERE a = '011011000100010111011000110000100'; + +SELECT count(*) FROM bittmp WHERE a >= '011011000100010111011000110000100'; + +SELECT count(*) FROM bittmp WHERE a > '011011000100010111011000110000100'; |