diff options
Diffstat (limited to 'contrib/btree_gist/expected/bit.out')
| -rw-r--r-- | contrib/btree_gist/expected/bit.out | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/contrib/btree_gist/expected/bit.out b/contrib/btree_gist/expected/bit.out index ae823046002..8606baf366e 100644 --- a/contrib/btree_gist/expected/bit.out +++ b/contrib/btree_gist/expected/bit.out @@ -64,3 +64,13 @@ SELECT count(*) FROM bittmp WHERE a > '011011000100010111011000110000100'; 350 (1 row) +-- Test index-only scans +SET enable_bitmapscan=off; +EXPLAIN (COSTS OFF) +SELECT a FROM bittmp WHERE a BETWEEN '1000000' and '1000001'; + QUERY PLAN +----------------------------------------------------------------------- + Index Only Scan using bitidx on bittmp + Index Cond: ((a >= B'1000000'::"bit") AND (a <= B'1000001'::"bit")) +(2 rows) + |