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/sql/rtree_gist.sql | 38 +++++++++++++++++++++++++++++++++++
 1 file changed, 38 insertions(+)
 create mode 100644 contrib/rtree_gist/sql/rtree_gist.sql

(limited to 'contrib/rtree_gist/sql/rtree_gist.sql')

diff --git a/contrib/rtree_gist/sql/rtree_gist.sql b/contrib/rtree_gist/sql/rtree_gist.sql
new file mode 100644
index 00000000000..a0506213227
--- /dev/null
+++ b/contrib/rtree_gist/sql/rtree_gist.sql
@@ -0,0 +1,38 @@
+--
+-- first, define the datatype.  Turn off echoing so that expected file
+-- does not depend on contents of seg.sql.
+--
+\set ECHO none
+\i rtree_gist.sql
+\set ECHO all
+
+create table boxtmp (b box);
+
+\copy boxtmp from 'data/test_box.data'
+
+select count(*) from boxtmp where b && '(1000,1000,0,0)'::box;
+
+create index bix on boxtmp using rtree (b);
+
+select count(*) from boxtmp where b && '(1000,1000,0,0)'::box;
+
+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;
+
+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;
+
+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;
+
-- 
cgit v1.2.3

