Re: Re: PostgreSQL 7.0.2 Date Miscalculation

Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
>> --- ./results/horology.out      Mon Apr  2 17:06:59 2001
>> SELECT time with time zone '01:30' + interval '02:01' AS "03:31:00-08";
>> 03:31:00-08
>> -------------
>> !  03:31:00-07

> Hmm. This is just a badly designed regression test (I can say that,
> since it is probably mine ;)

> I was trying to exercise TIME WITH TIME ZONE with the *implicit* time
> zone for today. That really won't work in a testable way, since the
> result varies during the year :(

What I'm curious about is why I'm not seeing a failure on HPUX.  If your
explanation is right then this test should fail everywhere during
daylight savings season.

            regards, tom lane