From 16f85390f205dafc9d663c3bf777d682ccbdd1dd Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Thu, 31 May 2001 18:27:18 +0000
Subject: Support for emulating RTREE indexing in GiST.  Contributed by Oleg
 Bartunov and Teodor Sigaev.

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

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

diff --git a/contrib/rtree_gist/expected/rtree_gist.out b/contrib/rtree_gist/expected/rtree_gist.out
new file mode 100644
index 00000000000..86404e40d9e
--- /dev/null
+++ b/contrib/rtree_gist/expected/rtree_gist.out
@@ -0,0 +1,45 @@
+--
+-- first, define the datatype.  Turn off echoing so that expected file
+-- does not depend on contents of seg.sql.
+--
+\set ECHO none
+create table boxtmp (b box);
+\copy boxtmp from 'data/test_box.data'
+select count(*) from boxtmp where b && '(1000,1000,0,0)'::box;
+ count 
+-------
+     2
+(1 row)
+
+create index bix on boxtmp using rtree (b);
+select count(*) from boxtmp where b && '(1000,1000,0,0)'::box;
+ count 
+-------
+     2
+(1 row)
+
+drop index bix;
+create index bix on boxtmp using gist (b gist_box_ops);
+select count(*) from boxtmp where b && '(1000,1000,0,0)'::box;
+ count 
+-------
+     2
+(1 row)
+
+create table polytmp (p polygon);
+\copy polytmp from 'data/test_box.data'
+create index pix on polytmp using rtree (p);
+select count(*) from polytmp where p && '(1000,1000),(0,0)'::polygon;
+ count 
+-------
+     2
+(1 row)
+
+drop index pix;
+create index pix on polytmp using gist (p gist_poly_ops) with(islossy);
+select count(*) from polytmp where p && '(1000,1000),(0,0)'::polygon;
+ count 
+-------
+     2
+(1 row)
+
-- 
cgit v1.2.3