Peter,
> I'm a newbie to PL/SQL and need help badly. I'm trying to pass my array of
> id's to the function and then loop through until the array is empty. I know
> there must be atleast five things I'm doing wrong.
Simplified example:
CREATE FUNCTION test_array (
INT[] )
RETURNS INT AS '
DECLARE id_array ALIAS for $1;
count_it INT;
BEGIN
count_it := 1;
WHILE id_array[count_it] LOOP
count_it := count_it + 1;
END LOOP;
RETURN (count_it - 1);
END;'
LANGUAGE 'plpgsql';
returns the number of elements in the supplied array.
--
Josh Berkus
josh(at)agliodbs(dot)com
Aglio Database Solutions
San Francisco