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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings