|PostgreSQL Reference Manual - Volume 2 - Programming Guide|
by The PostgreSQL Global Development Group
Paperback (6"x9"), 408 pages
RRP £19.95 ($34.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
CONTINUE [ label ] [ WHEN expression ];
If no label is given, the next iteration of the innermost loop is begun. That is, control is passed back to the loop control expression (if any), and the body of the loop is re-evaluated. If label is present, it specifies the label of the loop whose execution will be continued.
WHEN is specified, the next iteration of the
loop is begun only if expression is
true. Otherwise, control passes to the statement after
CONTINUE can be used with all types of loops; it
is not limited to use with unconditional loops.
LOOP -- some computations EXIT WHEN count > 100; CONTINUE WHEN count < 50; -- some computations for count IN [50 .. 100] END LOOP;
|ISBN 0954612035||PostgreSQL Reference Manual - Volume 2 - Programming Guide||See the print edition|