Re: xml - Mailing list pgsql-general

From Pavel Stehule
Subject Re: xml
Date
Msg-id CAFj8pRDPK7Hf3kbm1NqQzfn4XhE+jcWR7eqd1Vy5DfBZhyoetw@mail.gmail.com
Whole thread Raw
In response to Re: xml  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general


2015-03-23 15:09 GMT+01:00 Tom Lane <tgl@sss.pgh.pa.us>:
Pavel Stehule <pavel.stehule@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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: scope quirk in copy in function
Next
From: Saimon
Date:
Subject: How to distinguish serialization errors from others using pqxx