Skip Headers
Previous
Previous
 
Next
Next

Special Conditions

The IS operator tests for special conditions, such as nulls, infinity and values that are not numbers.

Special Conditions Operators

Operator Description

IS INFINITE

Returns true if the expression is infinite, or false otherwise. For mappings only.

IS NAN

Returns true if the expression is not a number, or false otherwise. For mappings only.

IS NULL

Returns true if the expression is null, or false otherwise.


Syntax

expr IS [ NOT ] NULL

Example

13 IS NOT NULL is true.