diff options
Diffstat (limited to 'contrib/btree_gist/expected/btree_gist.out')
| -rw-r--r-- | contrib/btree_gist/expected/btree_gist.out | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/contrib/btree_gist/expected/btree_gist.out b/contrib/btree_gist/expected/btree_gist.out index ab6a789f61..eb67c2e7f7 100644 --- a/contrib/btree_gist/expected/btree_gist.out +++ b/contrib/btree_gist/expected/btree_gist.out @@ -7,35 +7,35 @@ psql:btree_gist.sql:10: WARNING: ProcedureCreate: type int4key is not yet defin psql:btree_gist.sql:15: WARNING: Argument type "int4key" is only a shell psql:btree_gist.sql:76: WARNING: ProcedureCreate: type tskey is not yet defined psql:btree_gist.sql:81: WARNING: Argument type "tskey" is only a shell -create table inttmp (b int4); +CREATE TABLE inttmp (b int4); \copy inttmp from 'data/test_btree.data' -create table tstmp ( t timestamp without time zone ); +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; +SELECT count(*) FROM inttmp WHERE b <=10; count ------- 11 (1 row) -select count(*) from tstmp where t < '2001-05-29 08:33:09'; +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 ); +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; +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'; +SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09'; count ------- 66 |