New contrib module for BTREE emulation in GiST.

From Oleg Bartunov and Teodor Sigaev.

1 files changed, 39 insertions, 0 deletions

diff --git a/contrib/btree_gist/expected/btree_gist.out b/contrib/btree_gist/expected/btree_gist.out
new file mode 100644
index 00000000000..fdcbfd598a8
--- /dev/null
+++ b/contrib/btree_gist/expected/btree_gist.out
@@ -0,0 +1,39 @@
+--
+-- first, define the datatype.  Turn off echoing so that expected file
+-- does not depend on contents of seg.sql.
+--
+\set ECHO none
+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;
+ count 
+-------
+    11
+(1 row)
+
+select count(*) from tstmp where t < '2001-05-29 08:33:09+04';
+ count 
+-------
+     7
+(1 row)
+
+-- 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;
+ count 
+-------
+    11
+(1 row)
+
+select count(*) from tstmp where t < '2001-05-29 08:33:09+04';
+ count 
+-------
+     7
+(1 row)
+