On Sun, Jul 26, 2009 at 3:30 PM, Nick Boutelier<namethis...@gmail.com> wrote: > Thanks Merlin, do you know what the syntax would be? Can't seem to > find it anywhere and im getting an error using 8.3.7
You will need to create a type to represent the record contained in the array, or use a table type (each table can also be used from a composite type). Inside your plpgsql function, DECLARE foos foo[]; BEGIN select array(select * from foo) into foos; ... :-) merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
