On May 16, 2006, at 16:30, Andrew Dunstan wrote:

It ought to be illegal to modify the loop control variable anyway, IMNSHO - it certainly is in Ada, the distant antecedent of pl/pgsql.

I agree, but I must say that it's incredibly useful to be able to increment by two as I go through a loop:

    FOR i IN 1 + offset .. 11 + offset LOOP
        total := total + substring(ean, i, 1)::INTEGER;
        i = i + 1;
    END LOOP;

Best,

David

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to