| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | "P(dot) Broennimann" <peter(dot)broennimann(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Output of query_to_xml |
| Date: | 2012-07-12 20:51:14 |
| Message-ID: | 1342126274.19702.1.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | codevally | 2012-07-12 22:06:23 | Re: PostgreSQL index issue |
| Previous Message | Sergey Konoplev | 2012-07-12 19:00:59 | Re: how much volatile is a function |