Re: Output of query_to_xml - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Output of query_to_xml
Date
Msg-id 1342126274.19702.1.camel@vanquo.pezone.net
Whole thread Raw
In response to Output of query_to_xml  ("P. Broennimann" <peter.broennimann@gmail.com>)
List pgsql-general
On tor, 2012-06-21 at 07:49 +0200, P. Broennimann wrote:
> select query_to_xml('select * from table12', true, true, '') into ...

> The result is OK but there is always an empty line:
>
> <row xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
>                                  *<-- Empty line here*
>  <vanoao>FG8976SDFRETG</vanoao>
>   <country_code>NL</country_code>
>  <build_date>2011-02-28</build_date>
>   <tcode>MFT</tcode>
>  <exterior_color_code>GAB</exterior_color_code>
>   <interior_color_code>TAFP</interior_color_code>
> </row>
>
> Is this supposed to be or is this a cosmetic bug?

No reason.  I think it just came out this way because there are so many
modes to handle, and you want some legible output in all of them.

I've removed outputting the extra newline in 9.3devel.



pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: how much volatile is a function
Next
From: arafatix@gmail.com
Date:
Subject: Re: Query to find sum of grouped counts from 2 tables