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.
nullif_expression::= NULLIF(scalar_expression, scalar_expression)
@see NullIfExpression @version 2.4 @since 2.4 @author Pascal Filion
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.
nullif_expression::= NULLIF(scalar_expression, scalar_expression)
@see NullIfExpression @version 2.4 @since 2.4 @author Pascal Filion
|
|
|
|
|
|
|
|
|
|
|
|
|
|