diff options
Diffstat (limited to 'contrib/rtree_gist/expected')
| -rw-r--r-- | contrib/rtree_gist/expected/rtree_gist.out | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/contrib/rtree_gist/expected/rtree_gist.out b/contrib/rtree_gist/expected/rtree_gist.out new file mode 100644 index 00000000000..86404e40d9e --- /dev/null +++ b/contrib/rtree_gist/expected/rtree_gist.out @@ -0,0 +1,45 @@ +-- +-- 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 gist_box_ops); +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 gist_poly_ops) with(islossy); +select count(*) from polytmp where p && '(1000,1000),(0,0)'::polygon; + count +------- + 2 +(1 row) + |