EXIT

Description

EXIT is used to terminated a loop

Click here to navigate to the PostgreSQL documentation page for this syntax.

The EXIT statement is fully supported.

Grammar Syntax

EXIT [ label ] [ WHEN boolean-expression ];

Sample Source Patterns

The EXIT statement with WHEN clause is transform to an IF THEN EXIT

Input

PostgreSQL

EXIT;

EXIT ablock;  -- causes exit from the ablock loop block

LOOP
    -- some computations
    EXIT WHEN count > 0;
END LOOP;

Snowflake

EXIT;

EXIT ablock;  -- causes exit from the ablock loop block

LOOP
    -- some computations
    IF (count > 0) THEN
        EXIT;
    END IF;
END LOOP;

Known Issues

No issues were found.

Related EWIs

No related EWIs.