Chris
Bruce Momjian wrote:
Time zone changes --- will be OK tomorrow.
---------------------------------------------------------------------------
Christopher Kings-Lynne wrote:
I'm still seeing Horology failures on FreeBSD 4.9...
See attached diff.
Chris
*** ./expected/horology.out Thu Sep 25 14:58:06 2003
--- ./results/horology.out Tue Oct 28 11:29:24 2003
***************
*** 577,583 ****
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
True ------
! t
(1 row)
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
--- 577,583 ----
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
True ------
! f
(1 row)
SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
***************
*** 589,595 ****
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";
--- 589,595 ----
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";
======================================================================
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org