Re: [PATCH] Add XMLText function (SQL/XML X038)

On 25.03.23 12:53, Pavel Stehule wrote:
>
> 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)