Re: Re: PostgreSQL 7.0.2 Date Miscalculation - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Re: PostgreSQL 7.0.2 Date Miscalculation
Date
Msg-id 3446.986314086@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL 7.0.2 Date Miscalculation  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: PostgreSQL 7.0.2 Date Miscalculation
Next
From: Thomas Lockhart
Date:
Subject: Re: Re: PostgreSQL 7.0.2 Date Miscalculation