>>> Tom Lane <[EMAIL PROTECTED]> 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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to