On Sun, Jul 26, 2009 at 3:30 PM, Nick Boutelier<namethisapp@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
