All Implemented Interfaces:
Expression

public final class CoalesceExpression extends AbstractSingleEncapsulatedExpression
A COALESCE expression returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.

The return type is the type returned by the arguments if they are all of the same type, otherwise it is undetermined.

BNF: coalesce_expression::= COALESCE(scalar_expression {, scalar_expression}+)
Since:
2.3
Version:
2.5