Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id E5EA64760F0
	for <pgsql-sql@postgresql.org>; Thu, 24 Oct 2002 03:56:58 -0400 (EDT)
Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52])
	by postgresql.org (Postfix) with SMTP id 63DA6476A70
	for <pgsql-sql@postgresql.org>; Thu, 24 Oct 2002 03:56:52 -0400 (EDT)
Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ;
 Thu Oct 24 09:56:47 2002 +0200
Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id JAA19790; Thu, 24 Oct 2002 09:56:46 +0200 (METDST)
Message-ID: <3DB7A7BE.F3F80ACF@rodos.fzk.de>
Date: Thu, 24 Oct 2002 09:56:46 +0200
From: Christoph Haller <ch@rodos.fzk.de>
X-Mailer: Mozilla 4.06 [en] (X11; I; HP-UX B.10.20 9000/780)
MIME-Version: 1.0
To: bhuvansql@myrealbox.com
Cc: pgsql-sql@postgresql.org
Subject: Re: 'next' or similar in plpgsql
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/323
X-Sequence-Number: 10040

>
> 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