for statement, adding a STEP clause? - Mailing list pgsql-hackers

From Jaime Casanova
Subject for statement, adding a STEP clause?
Date
Msg-id c2d9e70e0604282214j6a8a3011haac82dce885b4b4a@mail.gmail.com
Whole thread Raw
Responses Re: for statement, adding a STEP clause?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Autovacuum Logging
Next
From: Tom Lane
Date:
Subject: Re: for statement, adding a STEP clause?