Re: Is there a better way to do this?

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Is there a better way to do this?
Дата
Msg-id 73C57E0A-C87A-4B86-AE77-A2CE45B8B87C@seespotcode.net
обсуждение исходный текст
Ответ на Re: Is there a better way to do this?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Aug 28, 2007, at 19:30 , Tom Lane wrote:

> Michael Glaesemann <grzm@seespotcode.net> writes:
>> Note that interval '1 day' is not equal to interval '24 hours'. '1
>> day' can be 23 or 25 hours across daylight saving time boundaries.
>
> When you are adding to timestamp without time zone, they *are*
> interchangeable, since no daylight-savings arithmetic is involved.
> Michael's right for the case of adding to timestamp with time zone,
> though.

Ah, right. Thanks for pointing that out.

Michael Glaesemann
grzm seespotcode net



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: autovacuum not running
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question regarding autovacuum