1 files changed, 36 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/btree_gist.sql b/contrib/btree_gist/sql/btree_gist.sql
new file mode 100644
index 00000000000..d408105cc76
--- /dev/null
+++ b/contrib/btree_gist/sql/btree_gist.sql
@@ -0,0 +1,36 @@
+--
+-- first, define the datatype.  Turn off echoing so that expected file
+-- does not depend on contents of seg.sql.
+--
+\set ECHO none
+\i btree_gist.sql
+\set ECHO all
+
+create table inttmp (b int4);
+
+\copy inttmp from 'data/test_btree.data'
+
+create table tstmp ( t datetime );
+
+\copy tstmp from 'data/test_btree_ts.data'
+
+-- without idx
+
+select count(*) from inttmp where b <=10;
+
+select count(*) from tstmp where t < '2001-05-29 08:33:09+04';
+
+-- create idx
+
+create index aaaidx on inttmp using gist ( b );
+
+create index tsidx on tstmp using gist ( t );
+
+--with idx
+
+set enable_seqscan=off;
+
+select count(*) from inttmp where b <=10;
+
+select count(*) from tstmp where t < '2001-05-29 08:33:09+04';
+