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