diff options
Diffstat (limited to 'contrib/btree_gist/expected/varbit.out')
| -rw-r--r-- | contrib/btree_gist/expected/varbit.out | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/contrib/btree_gist/expected/varbit.out b/contrib/btree_gist/expected/varbit.out index e6765f4231f..538ace85c90 100644 --- a/contrib/btree_gist/expected/varbit.out +++ b/contrib/btree_gist/expected/varbit.out @@ -64,3 +64,13 @@ SELECT count(*) FROM varbittmp WHERE a > '1110100111010'::varbit; 50 (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) + |