From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Lynn Dobbs <lynn(dot)dobbs(at)creditlink(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: xmlelement AND timestamps. |
Date: | 2017-02-14 01:36:04 |
Message-ID: | 2e70906b-e7d4-4fff-f74d-078234c39671@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/13/2017 02:56 PM, Lynn Dobbs wrote:
> 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.
All I could find was this thread from 2009:
https://www.postgresql.org/message-id/41F26B729B014C3E8F20F5B7%40teje
which indicated it was fixed at that time.
>
> 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
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-02-14 02:10:40 | Re: xmlelement AND timestamps. |
Previous Message | Scott Mead | 2017-02-14 00:00:55 | Re: Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary). |