Thread: SELECT INTO an array

Hi!

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 ...;

when calling the function, I get a

ERROR:  array_in: Need to specify dimension

How do I specify such dimension?


Thanks
Alberto

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