| From: | "P(dot) Broennimann" <peter(dot)broennimann(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Output of query_to_xml |
| Date: | 2012-06-21 05:49:16 |
| Message-ID: | CACm4aU94UP=s7JpnXazU+RfGtEU_YkvqZLmVoK=UVyKgHVGs1g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi there
In my stored function I use:
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?
Thanks,
P.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Schwarzer | 2012-06-21 06:12:12 | Re: How to include Tablefunc as an extension |
| Previous Message | Stefan Schwarzer | 2012-06-21 05:40:59 | Re: Error message "psql: could not connect to server: No such file or directory" |