Re: 'next' or similar in plpgsql - Mailing list pgsql-sql

From Christoph Haller
Subject Re: 'next' or similar in plpgsql
Date
Msg-id 3DB7A7BE.F3F80ACF@rodos.fzk.de
Whole thread Raw
In response to 'next' or similar in plpgsql  (Bhuvan A <bhuvansql@myrealbox.com>)
List 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 by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Sum of Every Column
Next
From: andres javier garcia garcia
Date:
Subject: Basic question.