Re: pl/pgsql trigger: syntax error at or near "ELSEIF"

[Pavel Stehule <stehule@xxxxxxxxxxxxxxx>]

Hello

try


35.7.2.4. IF-THEN-ELSIF-ELSE

IF boolean-expression THEN
    statements
[ ELSIF boolean-expression THEN
    statements
[ ELSIF boolean-expression THEN
    statements
    ...]]
[ ELSE
    statements ]
END IF;

regards
Pavel


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster