diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-10-03 18:39:12 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-10-03 18:39:12 +0000 |
commit | 2d6b1f29fb647ecf2a05e9253e8e4321c8b9009a (patch) | |
tree | e1abd317aa63ff723d1635321743a7adf1f2c638 /contrib/btree_gist/expected | |
parent | 1226816e4e823c8e0acabb33f57a1b31378d9a41 (diff) | |
download | postgresql-2d6b1f29fb647ecf2a05e9253e8e4321c8b9009a.tar.gz postgresql-2d6b1f29fb647ecf2a05e9253e8e4321c8b9009a.zip |
Update incorrect expected file. Use 'timestamp without time zone'
datatype in test, to try to avoid any dependency on local time zone.
Diffstat (limited to 'contrib/btree_gist/expected')
-rw-r--r-- | contrib/btree_gist/expected/btree_gist.out | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/contrib/btree_gist/expected/btree_gist.out b/contrib/btree_gist/expected/btree_gist.out index fdcbfd598a8..2c7cbd620e5 100644 --- a/contrib/btree_gist/expected/btree_gist.out +++ b/contrib/btree_gist/expected/btree_gist.out @@ -5,7 +5,7 @@ \set ECHO none create table inttmp (b int4); \copy inttmp from 'data/test_btree.data' -create table tstmp ( t datetime ); +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; @@ -14,10 +14,10 @@ select count(*) from inttmp where b <=10; 11 (1 row) -select count(*) from tstmp where t < '2001-05-29 08:33:09+04'; +select count(*) from tstmp where t < '2001-05-29 08:33:09'; count ------- - 7 + 66 (1 row) -- create idx @@ -31,9 +31,9 @@ select count(*) from inttmp where b <=10; 11 (1 row) -select count(*) from tstmp where t < '2001-05-29 08:33:09+04'; +select count(*) from tstmp where t < '2001-05-29 08:33:09'; count ------- - 7 + 66 (1 row) |