I'm seeing this on my Linux box (kernel 2.4.18, glibc 2.2.4):
*** ./expected/horology.out Thu Sep 19 06:35:25 2002
--- ./results/horology.out Mon Oct 28 13:42:39 2002
***************
*** 537,549 ****
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' -
interval '1 day')) as "True";
True
------
! t
(1 row)
SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday'
+ interval '2 days')) as "True";
True
------
! t
(1 row)
SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
--- 537,549 ----
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' -
interval '1 day')) as "True";
True
------
! f
(1 row)
SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday'
+ interval '2 days')) as "True";
True
------
! f
(1 row)
SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
***************
*** 790,796 ****
+ interval '02:01' AS time with time zone) AS time) AS "03:31:00";
03:31:00
----------
! 03:31:00
(1 row)
SELECT CAST(cast(date 'today' + time with time zone '03:30'
--- 790,796 ----
+ interval '02:01' AS time with time zone) AS time) AS "03:31:00";
03:31:00
----------
! 02:31:00
(1 row)
SELECT CAST(cast(date 'today' + time with time zone '03:30'
======================================================================
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
