Prevent x005F from xml - Mailing list pgsql-general

From Peter Kroon
Subject Prevent x005F from xml
Date
Msg-id CAOh+DOmC9W2OG8d211EpprBuuTy9Mq_AqAxmvwEuLBH+N1RJDw@mail.gmail.com
Whole thread Raw
Responses Re: Prevent x005F from xml  (Peter Kroon <plakroon@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: ERROR: query has no destination for result data
Next
From: John R Pierce
Date:
Subject: Re: ERROR: query has no destination for result data