Menu

#39 Incorrect output for reltime column type

9.2rc
open
nobody
None
None
None
nobody
2014-12-01
2014-12-01
No

*** /Users/pavan/work/SOURCES/postgres-xl/src/test/regress/expected/reltime.out Thu Jul 3 16:35:37 2014
--- /Users/pavan/work/SOURCES/postgres-xl/src/test/regress/results/reltime.out Mon Dec 1 11:20:10 2014


*** 60,68 ****

SELECT '' AS one, * FROM RELTIME_TBL
WHERE RELTIME_TBL.f1 = reltime '@ 34 years' ORDER BY f1;
! one | f1
! -----+------------
! | @ 34 years
(1 row)

SELECT '' AS two, * FROM RELTIME_TBL
--- 60,68 ----

SELECT '' AS one, * FROM RELTIME_TBL
WHERE RELTIME_TBL.f1 = reltime '@ 34 years' ORDER BY f1;
! one | f1
! -----+----------
! | 34 years
(1 row)

SELECT '' AS two, * FROM RELTIME_TBL

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.