On Friday 27 March 2009 20:59:23 Tom Lane wrote:
> Done, but I noticed while testing that it's not real consistent:
>
> regression=# select xmlelement(name foo, 'infinity'::timestamp);
> ERROR: timestamp out of range
> DETAIL: XML does not support infinite timestamp values.
> regression=# select
--On Freitag, März 27, 2009 14:59:23 -0400 Tom Lane
wrote:
Should we consider doing something about that, or is it okay as-is?
I'd say yes, but i don't understand why xmlelement() doesn't call
map_sql_value_to_xml_value() already instead of calling the output function
directly?
--
Thank
Bernd Helmle writes:
> map_sql_value_to_xml_value() currently errors out with a more or less vague
> error message, when a date or timestamp datatype with an infinite value is
> converted to XML. This is likely to create some confusion, especially when
> you have to debug some complex procedure
map_sql_value_to_xml_value() currently errors out with a more or less vague
error message, when a date or timestamp datatype with an infinite value is
converted to XML. This is likely to create some confusion, especially when
you have to debug some complex procedures and involved XML conversio