>>> Tom Lane <tgl@sss.pgh.pa.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