Simple case expression

The syntax for the simple case expression in BNF is as follows:

Syntax

simple_case_expr ::=
  CASE primary_expr  WHEN expr THEN {result_expr| NULL }[ , ...]
  [ ELSE expr| NULL ]
  END

For more information, see CASE.