pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

'next' or similar in plpgsql
2+ messages / 2 participants
[nested] [flat]

* 'next' or similar in plpgsql
@ 2002-10-22 10:13 Bhuvan A <bhuvansql@myrealbox.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Bhuvan A @ 2002-10-22 10:13 UTC (permalink / raw)
  To: pgsql-sql

Hi,

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?

TIA.

regards, 
bhuvaneswaran




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: 'next' or similar in plpgsql
@ 2002-10-24 07:56 Christoph Haller <ch@rodos.fzk.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Christoph Haller @ 2002-10-24 07:56 UTC (permalink / raw)
  To: bhuvansql@myrealbox.com; +Cc: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-10-24 07:56 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-22 10:13 'next' or similar in plpgsql Bhuvan A <bhuvansql@myrealbox.com>
2002-10-24 07:56 Re: 'next' or similar in plpgsql Christoph Haller <ch@rodos.fzk.de>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox