diff options
Diffstat (limited to 'contrib/btree_gist/expected/btree_gist.out')
| -rw-r--r-- | contrib/btree_gist/expected/btree_gist.out | 102 |
1 files changed, 0 insertions, 102 deletions
diff --git a/contrib/btree_gist/expected/btree_gist.out b/contrib/btree_gist/expected/btree_gist.out deleted file mode 100644 index a1cb6102ab6..00000000000 --- a/contrib/btree_gist/expected/btree_gist.out +++ /dev/null @@ -1,102 +0,0 @@ --- --- first, define the datatype. Turn off echoing so that expected file --- does not depend on contents of btree_gist.sql. --- -\set ECHO none -psql:btree_gist.sql:8: NOTICE: type "int2key" is not yet defined -DETAIL: Creating a shell type definition. -psql:btree_gist.sql:13: NOTICE: argument type int2key is only a shell -psql:btree_gist.sql:25: NOTICE: type "int4key" is not yet defined -DETAIL: Creating a shell type definition. -psql:btree_gist.sql:30: NOTICE: argument type int4key is only a shell -psql:btree_gist.sql:42: NOTICE: type "int8key" is not yet defined -DETAIL: Creating a shell type definition. -psql:btree_gist.sql:47: NOTICE: argument type int8key is only a shell -psql:btree_gist.sql:59: NOTICE: type "float4key" is not yet defined -DETAIL: Creating a shell type definition. -psql:btree_gist.sql:64: NOTICE: argument type float4key is only a shell -psql:btree_gist.sql:77: NOTICE: type "float8key" is not yet defined -DETAIL: Creating a shell type definition. -psql:btree_gist.sql:82: NOTICE: argument type float8key is only a shell -psql:btree_gist.sql:392: NOTICE: type "tskey" is not yet defined -DETAIL: Creating a shell type definition. -psql:btree_gist.sql:397: NOTICE: argument type tskey is only a shell -CREATE TABLE int4tmp (b int4); -\copy int4tmp from 'data/test_btree.data' -CREATE TABLE int8tmp (b int8); -\copy int8tmp from 'data/test_btree.data' -CREATE TABLE float4tmp (b float4); -\copy float4tmp from 'data/test_btree.data' -CREATE TABLE float8tmp (b float8); -\copy float8tmp 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 int4tmp WHERE b <=10; - count -------- - 11 -(1 row) - -SELECT count(*) FROM int8tmp WHERE b <=10; - count -------- - 11 -(1 row) - -SELECT count(*) FROM float4tmp WHERE b <=10; - count -------- - 11 -(1 row) - -SELECT count(*) FROM float8tmp 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 int4tmp USING gist ( b ); -CREATE INDEX bbbidx ON int8tmp USING gist ( b ); -CREATE INDEX cccidx ON float4tmp USING gist ( b ); -CREATE INDEX dddidx ON float8tmp USING gist ( b ); -CREATE INDEX tsidx ON tstmp USING gist ( t ); ---with idx -SET enable_seqscan=off; -SELECT count(*) FROM int4tmp WHERE b <=10::int4; - count -------- - 11 -(1 row) - -SELECT count(*) FROM int8tmp WHERE b <=10::int8; - count -------- - 11 -(1 row) - -SELECT count(*) FROM float4tmp WHERE b <=10::float4; - count -------- - 11 -(1 row) - -SELECT count(*) FROM float8tmp WHERE b <=10::float8; - count -------- - 11 -(1 row) - -SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09'; - count -------- - 66 -(1 row) - |