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