[GENERAL] xmlelement AND timestamps.
| От | Lynn Dobbs |
|---|---|
| Тема | [GENERAL] xmlelement AND timestamps. |
| Дата | |
| Msg-id | 4aae1b54-2f30-4d14-254d-e7bcffaf73e5@creditlink.com обсуждение |
| Ответы |
Re: [GENERAL] xmlelement AND timestamps.
Re: [GENERAL] xmlelement AND timestamps. |
| Список | pgsql-general |
I just migrated from 9.2.4 to 9.6.1 and had several user created functions fail. Recreating the failure with "SELECT xmlelement(name foo, 'infinity'::timestamp) ERROR: timestamp out of range DETAIL: XML does not support infinite timestamp values. I don't find anything in the documentation that explains this. I consider this a regression. I have many tables that have a "starting" and "ending" timestamp that default to "-infinity" and "infinity" respectively. Any function I have that outputs xml containing those columns have to have those values cast to text. Lynn Dobbs -- Chief Technical Office CreditLink Corporation 858-496-1000 x 103
В списке pgsql-general по дате отправления: