Re: Re: PostgreSQL 7.0.2 Date Miscalculation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: PostgreSQL 7.0.2 Date Miscalculation
Дата
Msg-id 3446.986314086@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL 7.0.2 Date Miscalculation  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: PostgreSQL 7.0.2 Date Miscalculation
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: Re: PostgreSQL 7.0.2 Date Miscalculation