diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-10-18 18:41:22 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-10-18 18:41:22 +0000 |
| commit | aa4c702eac936964649f905741b4a99f4b489200 (patch) | |
| tree | 517d3c28aa3d28eb95b19c8676c940b5cefe2031 /contrib/btree_gist/expected/btree_gist.out | |
| parent | fb9bc342fffc157d6ca4b635aeeaccb3c1370b91 (diff) | |
| download | postgresql-aa4c702eac936964649f905741b4a99f4b489200.tar.gz postgresql-aa4c702eac936964649f905741b4a99f4b489200.zip | |
Update /contrib for "autocommit TO 'on'".
Create objects in public schema.
Make spacing/capitalization consistent.
Remove transaction block use for object creation.
Remove unneeded function GRANTs.
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 ab6a789f615..eb67c2e7f73 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 |