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.