Re: Horology failures
От | Bruce Momjian |
---|---|
Тема | Re: Horology failures |
Дата | |
Msg-id | 200310280340.h9S3eqs05050@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Horology failures (Christopher Kings-Lynne <chriskl@familyhealth.com.au>) |
Ответы |
Re: Horology failures
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: