From 2d6b1f29fb647ecf2a05e9253e8e4321c8b9009a Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 3 Oct 2001 18:39:12 +0000 Subject: Update incorrect expected file. Use 'timestamp without time zone' datatype in test, to try to avoid any dependency on local time zone. --- contrib/btree_gist/sql/btree_gist.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'contrib/btree_gist/sql/btree_gist.sql') diff --git a/contrib/btree_gist/sql/btree_gist.sql b/contrib/btree_gist/sql/btree_gist.sql index d408105cc76..31c778b7471 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'; -- cgit v1.2.3