Class NullIfExpression

  • All Implemented Interfaces:
    Expression

    public final class NullIfExpression
    extends AbstractDoubleEncapsulatedExpression
    NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression.

    NULLIF is equivalent to a searched CASE expression in which the two expressions are equal and the resulting expression is NULL.

    Returns the same type as the first expression.

    BNF: nullif_expression::= NULLIF(scalar_expression, scalar_expression)

    Version:
    2.5
    Author:
    Pascal Filion
    Since:
    2.3
    • Constructor Detail

      • NullIfExpression

        public NullIfExpression​(AbstractExpression parent)
        Creates a new NullIfExpression.
        Parameters:
        parent - The parent of this expression