On 2024-12-10 Tu 2:48 AM, Jim Jones wrote:
On 04.12.24 17:18, Jim Jones wrote:
I'd like to propose the implementation of XMLDocument (SQL/XML X030).
It basically returns an XML document from a given XML expression, e.g.
SELECT
xmldocument(
xmlelement(NAME foo,
xmlattributes(42 AS att),
xmlelement(NAME bar,
xmlconcat('va', 'lue'))
)
);
xmldocument
--------------------------------------
<foo att="42"><bar>value</bar></foo>
(1 row)
v1 attached attempts to implement XMLDocument() as described above.
Feedback welcome.
LGTM at a first glance.
Please add this to the next CommitFest if you haven't done already.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com