WHILE
Grammar Syntax
[<<label>>]
WHILE expression LOOP
statements
END LOOP [ label ];
Sample Source Patterns
Input Code:
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:
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.
Last updated