Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp

Поиск
Список
Период
Сортировка
От Petr Jelinek
Тема Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp
Дата
Msg-id 56251247.2080007@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On 2015-10-19 17:31, Tom Lane wrote:
> Степан Перлов <stepanperlov@gmail.com> writes:
>> In postgresql 9.3 it returns '-infinity'.
>
> So I see.  Apparently we broke something during 9.4 devel.
>

Yeah it's the commits c00c3249e and bda76c1c8. First one changed the
output to not use to_char so that we could produce correct ISO timestamp
and disallowed the infinity altogether, the second added custom handling
for infinity, but the code does not differentiate between negative and
positive infinity. I think the json code does not need to have custom
handling of infinity but could just call the EncodeSpecialTimestamp() if
it was exported from the timestamp module.

--  Petr Jelinek                  http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #13688: lack of return value in r_mark_regions()
Следующее
От: Tom Lane
Дата:
Сообщение: pg_regprefix() doesn't handle lookahead constraints correctly