From 16f85390f205dafc9d663c3bf777d682ccbdd1dd Mon Sep 17 00:00:00 2001 From: Tom Lane 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