IF statement

Executes lists of statements based on the first condition that evaluates to true.

This statement may only be used within a compound statement.

Syntax

IF condition  THEN { stmt ; } [...]
  [ { ELSEIF condition THEN { stmt ; } [...] } [...] ]
  [ ELSE { stmt ; } [...] ]
  END IF

Parameters

condition

Any expression evaluating to a BOOLEAN.
stmt

A SQL statement to execute if the condition is true.

Examples

> BEGIN
    DECLARE choice DOUBLE DEFAULT 3.9;
    DECLARE result STRING;
    IF choice < 2 THEN
      VALUES ('one fish');
    ELSEIF choice < 3 THEN
      VALUES ('two fish');
    ELSEIF choice < 4 THEN
      VALUES ('red fish');
    ELSEIF choice < 5 OR choice IS NULL THEN
      VALUES ('blue fish');
    ELSE
      VALUES ('no fish');
    END IF;
  END;
 red fish