diff options
Diffstat (limited to 'contrib/btree_gist/expected/btree_gist.out')
-rw-r--r-- | contrib/btree_gist/expected/btree_gist.out | 39 |
1 files changed, 0 insertions, 39 deletions
diff --git a/contrib/btree_gist/expected/btree_gist.out b/contrib/btree_gist/expected/btree_gist.out deleted file mode 100644 index 2c7cbd620e5..00000000000 --- a/contrib/btree_gist/expected/btree_gist.out +++ /dev/null @@ -1,39 +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 inttmp (b int4); -\copy inttmp from 'data/test_btree.data' -create table tstmp ( t timestamp without time zone ); -\copy tstmp from 'data/test_btree_ts.data' --- without idx -select count(*) from inttmp where b <=10; - count -------- - 11 -(1 row) - -select count(*) from tstmp where t < '2001-05-29 08:33:09'; - count -------- - 66 -(1 row) - --- create idx -create index aaaidx on inttmp using gist ( b ); -create index tsidx on tstmp using gist ( t ); ---with idx -set enable_seqscan=off; -select count(*) from inttmp where b <=10; - count -------- - 11 -(1 row) - -select count(*) from tstmp where t < '2001-05-29 08:33:09'; - count -------- - 66 -(1 row) - |