Re: [PATCH] Add XMLText function (SQL/XML X038) - Mailing list pgsql-hackers

so 25. 3. 2023 v 12:49 odesílatel Jim Jones <jim.jones@uni-muenster.de> napsal:

Hi,

This small patch proposes the implementation of the standard SQL/XML
function XMLText (X038). It basically converts a text parameter into an
xml text node. It uses the libxml2 function xmlEncodeSpecialChars[1] to
escape possible predefined entities.

This patch also contains documentation and regression tests.

Any thoughts?

+1

Pavel

Thanks!

I just realized that I forgot to add a few examples to my last message :D

postgres=# SELECT xmltext('foo ´/[({bar?})]\`');
      xmltext       
--------------------
 foo ´/[({bar?})]\`
(1 row)

postgres=# SELECT xmltext('foo & <bar>');
        xmltext        
-----------------------
 foo &amp; &lt;bar&gt;
(1 row)