Re: Type Categories for User-Defined Types

>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> and you have to remember that *any* domain created over a string
type
> will also be considered to be of string category.

> find_coercion_pathway
> is looking at types that it's already smashed to base types, so
> actually you can get an I/O conversion for a domain over one of
these
> types already!
>
> regression=# create domain d2 as varchar(2);
> CREATE DOMAIN
> regression=# select 123::int4::d2;
> d2
> ----
> 12
> (1 row)

I would find is surprising if a domain didn't share these properties
with its underlying type.

-Kevin