aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/expected/spgist.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/spgist.out')
-rw-r--r--src/test/regress/expected/spgist.out21
1 files changed, 21 insertions, 0 deletions
diff --git a/src/test/regress/expected/spgist.out b/src/test/regress/expected/spgist.out
index 9364b88bc22..1688e0e0a32 100644
--- a/src/test/regress/expected/spgist.out
+++ b/src/test/regress/expected/spgist.out
@@ -65,3 +65,24 @@ DETAIL: Valid values are between "10" and "100".
-- Modify fillfactor in existing index
alter index spgist_point_idx set (fillfactor = 90);
reindex index spgist_point_idx;
+-- Test index over a domain
+create domain spgist_text as varchar;
+create table spgist_domain_tbl (f1 spgist_text);
+create index spgist_domain_idx on spgist_domain_tbl using spgist(f1);
+insert into spgist_domain_tbl values('fee'), ('fi'), ('fo'), ('fum');
+explain (costs off)
+select * from spgist_domain_tbl where f1 = 'fo';
+ QUERY PLAN
+-----------------------------------------------
+ Bitmap Heap Scan on spgist_domain_tbl
+ Recheck Cond: ((f1)::text = 'fo'::text)
+ -> Bitmap Index Scan on spgist_domain_idx
+ Index Cond: ((f1)::text = 'fo'::text)
+(4 rows)
+
+select * from spgist_domain_tbl where f1 = 'fo';
+ f1
+----
+ fo
+(1 row)
+