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,
Pennsylvania19073