public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jim Jones <[email protected]>
To: Marcos Pegoraro <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: [email protected]
Cc: Vik Fearing <[email protected]>
Subject: Re: [PoC] XMLCast (SQL/XML X025)
Date: Sat, 29 Nov 2025 13:38:32 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAB-JLwbwL5HE3sFp1Q3b-D8z2k5==oHY-FWUakRo+G22sNxCHw@mail.gmail.com>
References: <[email protected]>
<CA+TgmoYXMhHtt3zO0KCQ4pzgvX57X9H36cfXzz3aFqF+eJqf+g@mail.gmail.com>
<[email protected]>
<CA+TgmobAeZj8DzfUath+9NojBAWPgaYNzcTC5wd_XHpw0cwzCA@mail.gmail.com>
<[email protected]>
<CA+Tgmoa95JDa-9e_o+S2bjjWqbmVz7gnS+nh6Fqp2bJxgJf+CA@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<CAB-JLwZWNYV5HrkYhnzb2+1iOwiyxqyH7vP9_5z=JSmEYuS5Og@mail.gmail.com>
<[email protected]>
<CAB-JLwZ2gLcduACXkQhDR8xR65ypOmRCoZQB1GqnKhO8=wCZzw@mail.gmail.com>
<[email protected]>
<CAB-JLwbwL5HE3sFp1Q3b-D8z2k5==oHY-FWUakRo+G22sNxCHw@mail.gmail.com>
On 29/11/2025 12:38, Marcos Pegoraro wrote:
> Em sex., 28 de nov. de 2025 às 17:07, Jim Jones <jim.jones@uni-
> muenster.de <mailto:[email protected]>> escreveu:
>
> Character data type in this sentence means the character types[1] as a
> category, not the type character or character varying.
>
> Yes, I understand that, but saying character confuses me a bit.
Perhaps listing the data types would make things easier to understand?
Something like:
* Casting is supported between xml and the built-in character
(character, character varying, or text), numeric, boolean, binary, and
date/time types. The date/time types (date, time with time zone,
timestamp with time zone, and interval) are converted to their
corresponding XML Schema types: xs:date, xs:time, xs:dateTime, and
xs:duration.
A bit too verbose for my taste, but I could live with it.
XMLSerialize does something similar:
"type can be character, character varying, or text..."
What do you think?
> Not really. XMLCast implements the type-specific lexical and semantic
> rules defined by SQL/XML, which apply only to base (non-domain) data
> types. Although the grammar permits a domain name as a target, the
> standard does not define any XML-specific semantics for domains.
> Supporting them would go beyond the scope of this patch, and users
> who need a domain can IMHO cast the XMLCast result afterward.
>
> Correct. So maybe would be fine to explain this on SGML part, because a
> domain is sometimes used just as an alias of a base type, without
> checking or any other feature.
If the user gets a "ERROR: unsupported target data type for XMLCast"
using a domain (being an alias for a base type or not) and the
documentation clearly lists the supported types, wouldn't that be
enough? If not, do you have anything in mind that we could add to the docs?
Thanks for the review
Best, Jim
view thread (33+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: [PoC] XMLCast (SQL/XML X025)
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox