Re: INSERT with a composite columnt from query - Mailing list pgsql-general

Reg Me Please wrote:
>
> What I'd need to do is to insert the results from f_compo() into
> the table TAB along with a value x.
>
> I expected somthing like this to work:
>
> insert into tab
>   select 42,row( c.* ) from f_compo() c;
>
> But I get
> ERROR:  cannot cast type record to compo

You need to add an explicit cast I believe.

INSERT INTO tab (x,c)
SELECT 42, ROW(c.*)::compo FROM f_compo() c;

Why you don't in the case of INSERT ... VALUES isn't immediately clear
to me.

--
   Richard Huxton
   Archonet Ltd