Re: Timezone database changes

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Timezone database changes
Дата
Msg-id 470CF09D.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: Timezone database changes  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
>>> On Wed, Oct 10, 2007 at  2:51 PM, in message
<470CE6E2.EE98.0025.0@wicourts.gov>, "Kevin Grittner"
<Kevin.Grittner@wicourts.gov> wrote: 
>>>> On Wed, Oct 10, 2007 at 12:23 PM, in message
> <470D0A90.9000401@sun.com>, Magne
> Mæhre <Magne.Mahre@Sun.COM> wrote: 
>> An interesting observation is that,
>> as far as I can tell, the original time zone is only applied when
> casting
>> the element to a string.  Apart from that, it's not used.
>  
> It's been a while since I looked at it, but my recollection is that
> much of the standard date/time math which people assert can't handle
> practical use cases do work if the timestamps and times WITH TIME
> ZONE have a time zone in the offset-from-UTC format.  I have yet to
> see anyone provide an example where this isn't true; if anyone has
> such an example, it would be instructive to see it.
Withdrawn.  Tom posted an example today which crossed mine in the
mail.
I see his point.
-Kevin



В списке pgsql-hackers по дате отправления:

Предыдущее
От: andy
Дата:
Сообщение: Re: full text search in 8.3
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Skytools committed without hackers discussion/review