summaryrefslogtreecommitdiff
path: root/contrib/rtree_gist/expected/rtree_gist.out
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/rtree_gist/expected/rtree_gist.out')
-rw-r--r--contrib/rtree_gist/expected/rtree_gist.out45
1 files changed, 0 insertions, 45 deletions
diff --git a/contrib/rtree_gist/expected/rtree_gist.out b/contrib/rtree_gist/expected/rtree_gist.out
deleted file mode 100644
index 74ac7e640d1..00000000000
--- a/contrib/rtree_gist/expected/rtree_gist.out
+++ /dev/null
@@ -1,45 +0,0 @@
---
--- 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);
-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);
-select count(*) from polytmp where p && '(1000,1000),(0,0)'::polygon;
- count
--------
- 2
-(1 row)
-