WHILE STATEMENT

Description

Repeats a sequence of statements so long as the boolean-expression evaluates to true.

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

While Statement is supported by Snowflake.

Grammar Syntax

[ <<label>> ]
WHILE boolean-expression LOOP
    statements
END LOOP [ label ];

Sample Source Patterns

Input

The only changes that are done to the If Statement, are the following

The boolean-expression is enclosed by parenthesis.

PostgreSQL

while counter < 5 loop
      Select AValue from ATable;
end loop;

Snowflake

WHILE (counter < 5) loop
    Select AValue from ATable;
end loop;

Known Issues

No issues were found.

Related EWIs

No related EWIs.