Re: 'next' or similar in plpgsql

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: bhuvansql(at)myrealbox(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: 'next' or similar in plpgsql
Date: 2002-10-24 07:56:46
Message-ID: 3DB7A7BE.F3F80ACF@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message peter 2002-10-24 08:12:48 grouping and first()
Previous Message Achilleus Mantzios 2002-10-24 07:36:54 Re: Sum of Every Column