BUG #7971: Xml special symbols are not unescaped when gettting value of Xml via xpath

The following bug has been logged on the website:

Bug reference: 7971
Logged by: Vilen
Email address: v.tambovtsev@live.ru
PostgreSQL version: 9.2.3
Operating system: Windows
Description:

I've found this bug has already been discussed with no result
http://postgresql.1045698.n5.nabble.com/XMLATTRIBUTES-vs-values-of-type-XML-tt4636331.html#none

SELECT unnest(xpath('/name/text()', xmlelement(name name, 'AT&T', null )))

This gives me 'AT&T' and
I have NO WAY inside pgsql to get 'At&t' value

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs