Re: timestamp with time zone a la sql99

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема Re: timestamp with time zone a la sql99
Дата
Msg-id Pine.LNX.4.44.0410252221150.2015-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: timestamp with time zone a la sql99  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
On Mon, 25 Oct 2004, Josh Berkus wrote:

> > The standard restrict the hour field to the interval 0-23, so there can
> > never be any compare between for example '1 day 1 hour' and '25 hours'.
> > This means that one can not add two intervals together to get a bigger
> > one but that it would still work to do timestamp+interval+interval.
> 
> Hour field of the timestamp, or hour field of interval?  There a world of 
> difference.

Hour field of an interval can be 0-23 according to the spec (doesn't say
that we need that restriction, but we do need to understand what the spec
say).

-- 
/Dennis Björklund



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: timestamp with time zone a la sql99
Следующее
От: Tom Lane
Дата:
Сообщение: Re: timestamp with time zone a la sql99