Re: SELECT INTO an array - Mailing list pgsql-novice

Alberto,

> I'm trying to write a PLPGSQL Function using an array as an internal
> variable, but I don't seem to succeed:
>
> CREATE FUNCTION ... RETURNS ... AS '
> DECLARE
>   l_record integer[2];
> BEGIN
>   SELECT INTO l_record col01, col02 FROM table01 WHERE ...;

You don't want an array for the above.  You want a RECORD.

-Josh