Re: Error message and infinite date and timestamp conversion in XML

Bernd Helmle <mailings@oopsware.de> 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 procedures and involved XML conversions. I 
> propose to add the attached DETAIL to this error message, so people will 
> get an idea what's currently going wrong.

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 xmlelement(name foo, xmlattributes('infinity'::timestamp as bar));
xmlelement      
 
-----------------------<foo bar="infinity"/>
(1 row)

Should we consider doing something about that, or is it okay as-is?
        regards, tom lane