Yea, this is because of daylight savings time --- it will be OK tomorrow.
--------------------------------------------------------------------------- PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug reference: 1128 > Logged by: J 6M > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.4 > > Operating system: powerpc-ibm-aix4.3.3.0 > > Description: horology tests fails while make check (7.4.2) > > Details: > > On a powerpc-ibm-aix4.3.3.0, while doing make check with 7.4.2, > horlogy test failed. (Was correct with 7.4.1.) > --- > > > *** ./expected/horology-solaris-1947.out Thu Sep 25 18:16:35 2003 > --- ./results/horology.out Mon Apr 5 13:09:38 2004 > *************** > *** 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
