Re: [PoC] XMLCast (SQL/XML X025)

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Vik Fearing <vik(at)postgresfriends(dot)org>
Subject: Re: [PoC] XMLCast (SQL/XML X025)
Date: 2025-11-28 18:27:15
Message-ID: CAB-JLwZ2gLcduACXkQhDR8xR65ypOmRCoZQB1GqnKhO8=wCZzw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Em sex., 28 de nov. de 2025 às 12:30, Jim Jones <jim(dot)jones(at)uni-muenster(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2025-11-28 18:29:15 Re: Remove unused function parameters, part 2: replication
Previous Message Mihail Nikalayeu 2025-11-28 18:21:06 Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY