Prevent x005F from xml

From: Peter Kroon <plakroon(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Prevent x005F from xml
Date: 2012-11-23 11:16:18
Message-ID: CAOh+DOmC9W2OG8d211EpprBuuTy9Mq_AqAxmvwEuLBH+N1RJDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When I run this query:
SELECT
xmlelement(name my_xslt_tag,
(SELECT XMLPARSE (CONTENT '<![CDATA[<foo>bar</foo><bar>foo</bar>]]>'))
)

I get this result:
"<my_x005F_xslt_tag><![CDATA[<foo>bar</foo><bar>foo</bar>]]></my_x005F_xslt_tag>"

Running soemthing similar in mssql prevents the x005F
SELECT 'data' AS p,'data' AS k
FOR XML RAW('xmlst')

How do I prevent the x005F in the tagname without changing the tagname?

Best,
Peter Kroon

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-11-23 11:19:15 Re: ERROR: query has no destination for result data
Previous Message Pavel Stehule 2012-11-23 11:13:16 Re: ERROR: query has no destination for result data