Postgres Pro
Downloads
Home   >   mailing lists

Re: query_to_xml() returns invalid XML when query returns no rows - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: query_to_xml() returns invalid XML when query returns no rows
Date
Msg-id 4a4ad503-c879-0afb-d307-c81107421422@2ndquadrant.com
Whole thread Raw
In response to Re: query_to_xml() returns invalid XML when query returns no rows  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view 
On 3/13/18 15:21, Thomas Kellerer wrote:
> I still think it's incorrect to return an empty (=invalid) XML instead of a NULL value though.

This behavior is specified in the SQL standard.  While an empty string
is not a valid XML "document", it is valid as XML "content".

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is there a way to create a functional index that tables tableoid column as an arg?
Next
From: Melvin Davidson
Date:
Subject: Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas