| 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
| 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 |