Re: INTERVAL SECOND limited to 59 seconds?

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: INTERVAL SECOND limited to 59 seconds?
Дата
Msg-id 4A2F2923.2010304@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: INTERVAL SECOND limited to 59 seconds?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
> Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
>>     regression=# select interval '1 1' hour;
>
> Hmm, not sure about that one.  We decided a week or two back that we
> don't want the thing discarding higher-order field values, and this
> seems pretty close to that.  As the code is set up (plus my patch)
> I think it's the case that only the rightmost field specification
> of the interval qualifier makes any difference for parsing the value;
> the leftmost field doesn't really affect what we think the constant
> means.  That seems like a nice simple consistency property ...

Sounds good.  I'm happy with it then.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: INTERVAL SECOND limited to 59 seconds?
Следующее
От: Mirko Sertic
Дата:
Сообщение: Mogwai ER-DesignerNG 1.7-SNAPSHOT available