FOR

Grammar Syntax

Integer variant

[<<label>>]
FOR name IN [ REVERSE ] expression .. expression LOOP
  statements
END LOOP [ label ];

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

CREATE OR REPLACE PROCEDURE procedure1 ()
AS $$
BEGIN
  FOR i IN 1..10 LOOP
    NULL;
  END LOOP;

  FOR i IN REVERSE 10..1 LOOP
    NULL;
  END LOOP;
END;
$$ LANGUAGE plpgsql;

Output Code:

Redshift

OUT -> Redshift_01.sql

CREATE OR REPLACE PROCEDURE procedure1 ()
RETURNS VARCHAR
LANGUAGE SQL
AS $$
BEGIN
  FOR i IN 1 TO 10 LOOP
    NULL;
  END LOOP;

  FOR i IN REVERSE 10 TO 1 LOOP
    NULL;
  END LOOP;
END;
$$;

Known Issues

There are no known issues.

Related EWIs.

1. SSC-EWI-PG0006: Reference a variable using the Label is not supported by Snowflake.