Re: XMLDocument (SQL/XML X030)

From: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
To: Chapman Flack <jcflack(at)acm(dot)org>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: XMLDocument (SQL/XML X030)
Date: 2025-01-21 10:58:28
Message-ID: dce70427-4a71-4b67-9767-e385c80c292e@uni-muenster.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 20.01.25 23:21, Chapman Flack wrote:
> Therefore I'm thinking that, given the specifics of our XML support,
> a fully conformant and efficient XMLDOCUMENT could be implemented
> just by returning its XML argument.

After your explanation, I tend to agree.

v3, attached, incorporates these changes and updates the regression
tests accordingly.

>
> That opens a question of whether it's worth the effort to supply
> it at all. Maybe it could reduce the surprise for people coming from
> another DBMS and finding it missing, and/or be a placeholder in case
> we ever implement enough more of the newer SQL/XML standard for it
> to have a real effect.

Although quite trivial, I believe this function could still be valuable
in facilitating the migration of scripts from other database systems --
improving SQL/XML conformance also isn't a bad thing :).

Thank you again for your help in interpreting the SQL/XML standard. Much
appreciated!

Best regards, Jim

Attachment Content-Type Size
v3-0001-Add-XMLDocument-function-SQL-XML-X030.patch text/x-patch 10.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ritu Bhandari 2025-01-21 11:15:59 Re: Purpose of wal_init_zero
Previous Message m.litsarev 2025-01-21 10:51:22 Re: pg_stat_statements: improve loading and saving routines for the dump file