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

From: v(dot)tambovtsev(at)live(dot)ru
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7971: Xml special symbols are not unescaped when gettting value of Xml via xpath
Date: 2013-03-19 15:30:46
Message-ID: E1UHyUw-0001oj-HE@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7971
Logged by: Vilen
Email address: v(dot)tambovtsev(at)live(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message Kapil Kr. Khandelwal 2013-03-20 12:21:42 Re: How to run query by command prompt in Postgres
Previous Message Heikki Linnakangas 2013-03-19 14:20:27 Re: BUG #7970: How 's list all members in a special tablespace ( not as pg_global & pg_default )