CASE Expression

The CASE expression can be used for conditional expressions in Splice Machine.

Syntax

You can place a CASE expression anywhere an expression is allowed. It chooses an expression to evaluate based on a boolean test.

CASE
  WHEN booleanExpression THEN thenExpression
  [ WHEN booleanExpression
    THEN thenExpression ]...
    ELSE elseExpression
END

thenExpression and elseExpression

Both are both that must be type-compatible. For built-in types, this means that the types must be the same or a built-in broadening conversion must exist between the types.

Example

   -- returns 3
 CASE WHEN 1=1 THEN 3 ELSE 4 END;

  -- returns 7
 CASE
   WHEN 1 = 2 THEN 3
   WHEN 4 = 5 THEN 6
   ELSE 7
 END;