From a9289708af0bff1c45deae79a7c8f6db75d8ca16 Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Wed, 22 Aug 2001 18:27:54 +0000
Subject: New contrib module for BTREE emulation in GiST. From Oleg Bartunov
 and Teodor Sigaev.

---
 contrib/btree_gist/expected/btree_gist.out | 39 ++++++++++++++++++++++++++++++
 1 file changed, 39 insertions(+)
 create mode 100644 contrib/btree_gist/expected/btree_gist.out

(limited to 'contrib/btree_gist/expected/btree_gist.out')

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)
+
-- 
cgit v1.2.3