| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> | 
|---|---|
| To: | Chris Ruprecht <chrup999(at)yahoo(dot)com> | 
| Cc: | p-sql <pgsql-sql(at)postgresql(dot)org> | 
| Subject: | Re: TODO List | 
| Date: | 2001-07-20 16:56:31 | 
| Message-ID: | 200107201656.f6KGuVA21002@candle.pha.pa.us | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-07-20 17:05:16 | Re: Query optimizing - paradox behave | 
| Previous Message | Jeff Eckermann | 2001-07-20 16:23:32 | RE: Records exactly the same. |