aboutsummaryrefslogtreecommitdiff
path: root/contrib/rtree_gist/sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2005-07-01 19:23:07 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2005-07-01 19:23:07 +0000
commite6a8eba3f2157bca9871539e6be1ca2399c1371e (patch)
tree11f525dd537fb20c3a4c4750f3b519d36127939f /contrib/rtree_gist/sql
parente7e1694295e3d867f07afedf6505d0e0436cb67e (diff)
downloadpostgresql-e6a8eba3f2157bca9871539e6be1ca2399c1371e.tar.gz
postgresql-e6a8eba3f2157bca9871539e6be1ca2399c1371e.zip
Remove contrib version of rtree_gist --- now in core system.
Diffstat (limited to 'contrib/rtree_gist/sql')
-rw-r--r--contrib/rtree_gist/sql/rtree_gist.sql47
1 files changed, 0 insertions, 47 deletions
diff --git a/contrib/rtree_gist/sql/rtree_gist.sql b/contrib/rtree_gist/sql/rtree_gist.sql
deleted file mode 100644
index 73435c0b3de..00000000000
--- a/contrib/rtree_gist/sql/rtree_gist.sql
+++ /dev/null
@@ -1,47 +0,0 @@
---
--- 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);
-
-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);
-
-SELECT count(*)
-FROM polytmp
-WHERE p && '(1000,1000),(0,0)'::polygon;