Postgres Pro
Downloads
Home   >   mailing lists

BUG #7971: Xml special symbols are not unescaped when gettting value of Xml via xpath - Mailing list pgsql-bugs

From v.tambovtsev@live.ru
Subject BUG #7971: Xml special symbols are not unescaped when gettting value of Xml via xpath
Date
Msg-id E1UHyUw-0001oj-HE@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
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 =

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #7970: How 's list all members in a special tablespace ( not as pg_global & pg_default )
Next
From: "Kapil Kr. Khandelwal"
Date:
Subject: Re: How to run query by command prompt in Postgres