Re: TODO List - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: TODO List
Date
Msg-id 200107201656.f6KGuVA21002@candle.pha.pa.us
Whole thread Raw
In response to TODO List  ("Chris Ruprecht" <chrup999@yahoo.com>)
Responses Re: TODO List
List pgsql-sql
> Bruce,
> 
> while you're at TO-DO list additions:
> 
> I'd like to have a construct like:
> 
> loop
>     if <condition> then
>       next [loop];
>     end if;
>     [more statements]
> end loop;
> 
> I want to be able to skip to the next iteration of the loop, if a certain
> condition is met but I do not want to exit the loop all together. There
> doesn't seem to be functionality for that right now.

You want C 'continue' statement.  Is that for Pl/pgSQL?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: "Magnus Landahl"
Date:
Subject: Get the tables names?
Next
From: Nils Zonneveld
Date:
Subject: Re: Records exactly the same.