Em sex., 28 de nov. de 2025 às 12:30, Jim Jones <[email protected]>
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
