Re: [GENERAL] Looping through Arrays

[Merlin Moncure]

On 10/10/06, adam lawrence <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster