Thread: 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 =