Re: Dynamic insert into ARRAY? plpgsql

George Ant wrote
> Thank you for your Response!
>
> Inserting a sub-select into the array seems to be the solution that I
> want, but it gives me this error--> subquery must return only one column
>
> Any help?
>
> Kind Regards,
> George Ant

In both cases you want to be storing a single composite type column.  So
your sub-select has to use row(...)::composite_type in the select.  Just
like your original query did.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Dynamic-insert-into-ARRAY-plpgsql-tp5791090p5791110.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.