Re: Extracting fields from 'infinity'::TIMESTAMP[TZ]

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Extracting fields from 'infinity'::TIMESTAMP[TZ]
Дата
Msg-id 31678.1447775867@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Extracting fields from 'infinity'::TIMESTAMP[TZ]  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Ответы Re: Extracting fields from 'infinity'::TIMESTAMP[TZ]  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Vitaly Burovoy <vitaly.burovoy@gmail.com> writes:
> I suppose behavior of monotonic values (julian, century, decade,
> isoyear, millennium and year) should be the same as for epoch (which
> obviously also monotonic value).
> Proposed patch has that behavior: +/-infinity for epoch, julian,
> century, decade, isoyear, millennium and year; NULL for other fields.

Works for me.
        regards, tom lane



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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Freeze avoidance of very large table.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Extracting fields from 'infinity'::TIMESTAMP[TZ]