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.
P.
