diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-01 19:23:07 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-01 19:23:07 +0000 |
commit | e6a8eba3f2157bca9871539e6be1ca2399c1371e (patch) | |
tree | 11f525dd537fb20c3a4c4750f3b519d36127939f /contrib/rtree_gist/sql | |
parent | e7e1694295e3d867f07afedf6505d0e0436cb67e (diff) | |
download | postgresql-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.sql | 47 |
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; |