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

From Jim Jones
Subject Re: [PATCH] Add XMLText function (SQL/XML X038)
Date
Msg-id 524d15f3-b16c-dba0-2b76-cb66d09430f2@uni-muenster.de
Whole thread Raw
In response to Re: [PATCH] Add XMLText function (SQL/XML X038)  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [PATCH] Add XMLText function (SQL/XML X038)
List pgsql-hackers
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)

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [PATCH] Add XMLText function (SQL/XML X038)
Next
From: Andrew Dunstan
Date:
Subject: meson/msys2 fails with plperl/Strawberry