Horology failures

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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

I thought you said that yesterday?

Chris

Bruce Momjian wrote:

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

I'm still seeing Horology failures on FreeBSD 4.9...

Should stop at midnight Tuesday, PST8PDT time (about 45 minutes
from now) ... see prior discussion ...

regards, tom lane

I said:

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

I'm still seeing Horology failures on FreeBSD 4.9...

Should stop at midnight Tuesday, PST8PDT time (about 45 minutes
from now) ... see prior discussion ...

Argh ... make that "3 hours from now" ... you'd think I could remember
the time shift between here and the Left Coast ...

regards, tom lane

er, plus 3 hours, I think, i.e. just under 2 hours from now ... (unless you
posted this in the future :-) )

[andrew@alphonso andrew]$ TZ=PST8PDT date
Mon Oct 27 22:07:22 PST 2003
[andrew@alphonso andrew]$ date
Tue Oct 28 01:07:28 EST 2003
[andrew@alphonso andrew]$

cheers

andrew

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: "Hackers" <pgsql-hackers@postgresql.org>
Sent: Monday, October 27, 2003 11:16 PM
Subject: Re: [HACKERS] Horology failures

Oops, I have two words for you, "yesterday" and "tomorrow". ;-)

Seems the problem spans almost three days.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:

I thought you said that yesterday?

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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073