WHILE

Grammar Syntax

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

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

CREATE OR REPLACE PROCEDURE simple_loop_when()
    LANGUAGE plpgsql
AS $$
DECLARE
    i INTEGER := 0;
BEGIN
    WHILE I > 5 AND I > 10 LOOP
        NULL;
    END LOOP;   
END;
$$;

Output Code:

Redshift

OUT -> Redshift_01.sql

CREATE OR REPLACE PROCEDURE simple_loop_when ()
RETURNS VARCHAR
    LANGUAGE SQL
AS $$
DECLARE
    i INTEGER := 0;
BEGIN
    WHILE (I > 5 AND I > 10) LOOP
        NULL;
    END LOOP ;
END;
$$;

Known Issues

There are no known issues.

Related EWIs.

There are no related EWIs.