Here's another example of domain casting not working right:

create domain foo as varchar;
select cast(x.y as foo) from (select 'foo') as x(y);
ERROR:  coerce_type: no conversion function from "unknown" to foo

-- 
Peter Eisentraut   peter_e@gmx.net


Sat, 28 Jun 2003 17:45:15 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Domain casting still doesn't work right
Peter Eisentraut <peter_e@gmx.net> writes:
> Here's another example of domain casting not working right:
> create domain foo as varchar;
> select cast(x.y as foo) from (select 'foo') as x(y);
> ERROR:  coerce_type: no conversion function from "unknown" to foo

Not the domain's fault.  You get the same error without it:

regression=# select cast(x.y as varchar) from (select 'foo') as x(y);
ERROR:  coerce_type: no conversion function from "unknown" to character varying

The problem, if it is one, is that the subselect's output column is
irrevocably assigned the datatype "unknown" when we form the subselect
result list.  We could make this particular problem go away by coercing
the subselect result to text, but that would create problems in other
areas, notably UNIONs.  In a UNION you need to leave the individual
subselect's outputs typed as unknown as long as possible, so that they
don't screw up a type assignment derived from another subselect where
the column isn't an untyped literal.

			regards, tom lane

Sat, 28 Jun 2003 12:02:00 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Domain casting still doesn't work right 