docs/control-flow/if-stmt.md
Executes lists of statements based on the first condition that evaluates to true.
This statement may only be used within a compound statement.
IF condition THEN { stmt ; } [...]
[ { ELSEIF condition THEN { stmt ; } [...] } [...] ]
[ ELSE { stmt ; } [...] ]
END IF
condition
Any expression evaluating to a BOOLEAN.
stmt
A SQL statement to execute if the condition is true.
> BEGIN
DECLARE choice DOUBLE DEFAULT 3.9;
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