Search Postgresql Archives

xmlelement AND timestamps.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux