Re: [PoC] XMLCast (SQL/XML X025) - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: [PoC] XMLCast (SQL/XML X025)
Date
Msg-id CAB-JLwZ2gLcduACXkQhDR8xR65ypOmRCoZQB1GqnKhO8=wCZzw@mail.gmail.com
Whole thread Raw
In response to Re: [PoC] XMLCast (SQL/XML X025)  (Jim Jones <jim.jones@uni-muenster.de>)
Responses Re: [PoC] XMLCast (SQL/XML X025)
List pgsql-hackers
Em sex., 28 de nov. de 2025 às 12:30, Jim Jones <jim.jones@uni-muenster.de> escreveu:
With "character type" I meant to include text, varchar, and char, as in
the docs[1]

You wrote character only on the SGML part, all others are text. When you write numeric, the user understands that it can be bigint, integer, numeric, etc, so users can get confused about TEXT and CHAR(N), because the only place you wrote character is on SGML.

And interval is still not on that list. With text and interval types.

+          It supports casting between <type>xml</type> and text, numeric, date/time, boolean, binary and interval data types. 

And about domains
+ switch (xexpr->targetType)
+ {
+ case XMLOID:
...
+ case INT4OID:

Does this shape capture this type ?
CREATE DOMAIN i32 AS integer;

regards
Marcos

pgsql-hackers by date:

Previous
From: Mihail Nikalayeu
Date:
Subject: Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY
Next
From: Bertrand Drouvot
Date:
Subject: Re: Remove unused function parameters, part 2: replication