Re: Is there a RECORD[] type in plpgsql?

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