Re: XMLDocument (SQL/XML X030)

From: Robert Treat <rob(at)xzilla(dot)net>
To: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
Cc: Chapman Flack <jcflack(at)acm(dot)org>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: XMLDocument (SQL/XML X030)
Date: 2025-01-21 22:45:02
Message-ID: CABV9wwMCN9FaprXhbP5ivkvKCuhBOiVTsOf7Ne6M566QXMRpzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 21, 2025 at 5:58 AM Jim Jones <jim(dot)jones(at)uni-muenster(dot)de> wrote:
> 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 :).
>

Is there some concrete use case you have seen that this would help
with? Not objecting to adding it, but you've mentioned this migration
idea twice but it seems to me this doesn't conform with existing
implementations, and I don't see much benefit in migration use cases
specifically, so I'm just curious if I am overlooking something?

Robert Treat
https://xzilla.net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Melih Mutlu 2025-01-21 22:54:32 Re: speedup COPY TO for partitioned table.
Previous Message Tom Lane 2025-01-21 21:30:17 Re: attndims, typndims still not enforced, but make the value within a sane threshold