Class CoalesceExpression

  • 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}+)
    Version:
    2.5
    Author:
    Pascal Filion
    Since:
    2.3