Re: breaking out of a loop in plpgsql

On Thu, 2005-06-09 at 12:35 -0500, Celia McInnis wrote:
> How do I break out of a loop in plpgsql?

From the plpgsql docs:

        EXIT [ label ] [ WHEN expression ];

        If no label is given, the innermost loop is terminated and the
        statement following END LOOP is executed next. If label is
        given, it must be the label of the current or some outer level
        of nested loop or block. Then the named loop or block is
        terminated and control continues with the statement after the
        loop's/block's corresponding END.

        If WHEN is present, loop exit occurs only if the specified
        condition is true, otherwise control passes to the statement
        after EXIT.

        EXIT can be used to cause early exit from all types of loops; it
        is not limited to use with unconditional loops.