On 10/10/06, adam lawrence <name_adam(at)yahoo(dot)com(dot)au> wrote:
> But now I need to loop through the whole array, not just the one element. I
> want to do something like:
>
> FOR j in ....LOOP
> FOR i IN array_lower(arrayvar,1) .. array_upper(arrayvar,1) LOOP
> currentvalue:=arrayvar[j][i];
> RAISE NOTICE '%', currentvalue;
> END LOOP;
> END LOOP;
>
> How to I set the upper and lower bounds for j?
FOR j IN array_lower(arrayvar, 2)..array_upper(arrayvar, 2) LOOP
:-)
merlin