for statement, adding a STEP clause?

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема for statement, adding a STEP clause?
Дата
Msg-id c2d9e70e0604282214j6a8a3011haac82dce885b4b4a@mail.gmail.com
обсуждение исходный текст
Ответы Re: for statement, adding a STEP clause?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Autovacuum Logging
Следующее
От: Tom Lane
Дата:
Сообщение: Re: for statement, adding a STEP clause?