2015-03-23 15:09 GMT+01:00 Tom Lane <t...@sss.pgh.pa.us>:

> Pavel Stehule <pavel.steh...@gmail.com> writes:
> > result of xmlagg is not valid xml.
>
> Really?  Either that's a bug, or it's declared wrong.
>

I was not accurate. "<tag /><tag />" is not valid xml document - and xpath
function doens't like it.

postgres=# select xpath('//tag/@x','<tag x="x"/><tag />'::xml);
ERROR:  could not parse XML document
DETAIL:  line 1: Extra content at the end of the document
<tag x="x"/><tag />
            ^
CONTEXT:  SQL function "xpath" statement 1
postgres=# select xpath('//tag/@x','<x><tag x="x"/><tag /></x>'::xml);
 xpath
-------
 {x}
(1 row)

postgres=# select '<tag x="x"/><tag />'::xml;
         xml
---------------------
 <tag x="x"/><tag />
(1 row)


Regards

Pavel


>
>                         regards, tom lane
>

Reply via email to