for statement, adding a STEP clause?

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: for statement, adding a STEP clause?
Date: 2006-04-29 05:14:17
Message-ID: c2d9e70e0604282214j6a8a3011haac82dce885b4b4a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

there is a chance to add a STEP clause to the FOR statement in plpgsql?

something like

FOR i IN 1..100 STEP 2 LOOP
END LOOP

the STEP value must be a positive value because of the effect of the
REVERSE clause...

i think it's just a matter of fixing gram.y, plpgsql.h (to add
another PLpgSQL_expr to the stmt_fori) and pl_exec.c (the way the
internal variable is incremented here makes me think that i wasn't the
first one with this idea)

i'm missing something? is "STEP" a good name for this? i will make a
try tomorrow

any ideas and suggestions are welcome...

--
regards,
Jaime Casanova

"What they (MySQL) lose in usability, they gain back in benchmarks, and that's
all that matters: getting the wrong answer really fast."
Randal L. Schwartz

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-04-29 05:50:55 Re: for statement, adding a STEP clause?
Previous Message Tom Lane 2006-04-29 01:54:17 Re: [GENERAL] Autovacuum Logging