Re: 'next' or similar in plpgsql

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема Re: 'next' or similar in plpgsql
Дата
Msg-id 3DB7A7BE.F3F80ACF@rodos.fzk.de
обсуждение исходный текст
Ответ на 'next' or similar in plpgsql  (Bhuvan A <bhuvansql@myrealbox.com>)
Список pgsql-sql
>
> In perl we have 'next' function to skip rest of the statements in the
loop
> and to start with next iteration. In plpgsql, do we have something
> similar? How do we skip rest of the statements in a loop in plpgsql?
>
The only statement which can be used in a probably tricky way seems to
be
EXIT [ label ] [ WHEN expression ];
What you are really looking for is something like the C statement
"continue;"
I'm quite surprised this is not available in plpgsql.

Regards, Christoph



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

Предыдущее
От: Achilleus Mantzios
Дата:
Сообщение: Re: Sum of Every Column
Следующее
От: andres javier garcia garcia
Дата:
Сообщение: Basic question.