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

[Merlin Moncure <mmoncure@xxxxxxxxx>]

On Sun, Jul 26, 2009 at 3:30 PM, Nick Boutelier<namethisapp@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general