aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--contrib/btree_gist/expected/btree_gist.out10
-rw-r--r--contrib/btree_gist/sql/btree_gist.sql6
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 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)
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';