Re: Horology failures

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