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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
