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 [EMAIL PROTECTED] so that your > >> message can get through to the mailing list cleanly > > > > > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html