Re: plpgsql FOR loop doesn't guard against strange step values

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: plpgsql FOR loop doesn't guard against strange step values
Дата
Msg-id 200707142233.22579.peter_e@gmx.net
обсуждение исходный текст
Ответ на plpgsql FOR loop doesn't guard against strange step values  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: plpgsql FOR loop doesn't guard against strange step values
Список pgsql-hackers
Tom Lane wrote:
> I just noticed that when the BY option was added to plpgsql FOR
> loops, no real error checking was done.  If you specify a zero step
> value, you'll have an infinite loop.  If you specify a negative
> value, the loop variable will increment in the "wrong direction"
> until integer overflow occurs.  Neither of these behaviors seem
> desirable in the least.

That seems to be fairly normal proramming language behavior.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: plpgsql FOR loop doesn't guard against strange step values
Следующее
От: Tom Lane
Дата:
Сообщение: plpgsql and qualified variable names