diff options
Diffstat (limited to 'contrib/rtree_gist/expected/rtree_gist.out')
-rw-r--r-- | contrib/rtree_gist/expected/rtree_gist.out | 45 |
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) - |