Actually, xpath()'s output is not original XML, at least there must be a function like XML_UNESCAPE() for current
behavior
otherwise there is no way to get proper xml with xpath
--
Вилен Тамбовцев
----------------------------------------
> From: tgl@sss.pgh.pa.us
> To: v.tambovtsev@outlook.com
> CC: pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #8469: Xpath behaviour unintuitive / arguably wrong
> Date: Tue, 3 Feb 2015 17:09:34 -0500
>
> Вилен Тамбовцев <v.tambovtsev@outlook.com> writes:
>> Any news on this bug? 9.4 still behaves wrong and this actively stops us from using Postgresql as a storage for our
xmldocs.
>
> AFAICS the conclusion in that thread was that the current behavior is
> correct; in particular xpath()'s output is still XML and so it must not
> de-escape anything.
>
> http://www.postgresql.org/message-id/72DA66D9-0222-4888-AF55-61D3337CAC7A@phlo.org
>
> regards, tom lane
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs