Re: [PoC] XMLCast (SQL/XML X025)
| От | Marcos Pegoraro |
|---|---|
| Тема | Re: [PoC] XMLCast (SQL/XML X025) |
| Дата | |
| Msg-id | CAB-JLwZ2gLcduACXkQhDR8xR65ypOmRCoZQB1GqnKhO8=wCZzw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [PoC] XMLCast (SQL/XML X025) (Jim Jones <jim.jones@uni-muenster.de>) |
| Ответы |
Re: [PoC] XMLCast (SQL/XML X025)
|
| Список | 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;
+ switch (xexpr->targetType)
+ {
+ case XMLOID:
...
+ case INT4OID:
Does this shape capture this type ?
CREATE DOMAIN i32 AS integer;
regards
Marcos
В списке pgsql-hackers по дате отправления: