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 | |
| parent | 1226816e4e823c8e0acabb33f57a1b31378d9a41 (diff) | |
| download | postgresql-2d6b1f29fb647ecf2a05e9253e8e4321c8b9009a.tar.gz | |
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')
| -rw-r--r-- | contrib/btree_gist/expected/btree_gist.out | 10 | ||||
| -rw-r--r-- | contrib/btree_gist/sql/btree_gist.sql | 6 |
2 files changed, 8 insertions, 8 deletions
diff --git a/contrib/btree_gist/expected/btree_gist.out b/contrib/btree_gist/expected/btree_gist.out index fdcbfd598a..2c7cbd620e 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) diff --git a/contrib/btree_gist/sql/btree_gist.sql b/contrib/btree_gist/sql/btree_gist.sql index d408105cc7..31c778b747 100644 --- a/contrib/btree_gist/sql/btree_gist.sql +++ b/contrib/btree_gist/sql/btree_gist.sql @@ -10,7 +10,7 @@ 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' @@ -18,7 +18,7 @@ create table tstmp ( t datetime ); select count(*) from inttmp where b <=10; -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'; -- create idx @@ -32,5 +32,5 @@ set enable_seqscan=off; select count(*) from inttmp where b <=10; -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'; |