IS INFINITE Predicate

An IS INFINITE predicate determines whether an expression is infinite (positive infinity (INF) or negative infinity (-INF)).

SQL syntax

Expression IS [NOT] INFINITE

Parameters

Parameter Description

Expression

Expression to test.

Description

  • An IS INFINITE predicate evaluates to TRUE if the expression is positive or negative infinity.

  • An IS NOT INFINITE predicate evaluates to TRUE if expression is neither positive nor negative infinity.

  • The expression must either resolve to a numeric data type or to a data type that can be implicitly converted to a numeric data type.

  • Two positive infinity values are equal to each other. Two negative infinity values are equal to each other.

  • Expressions containing floating-point values may generate Inf, -Inf, or NaN. This can occur either because the expression generated overflow or exceptional conditions or because one or more of the values in the expression was Inf, -Inf, or NaN. Inf and NaN are generated in overflow or division by 0 conditions.

  • Inf, -Inf, and NaN values are not ignored in aggregate functions. NULL values are. If you want to exclude Inf and NaN from aggregates (or from any selection), use both the IS NOT NAN and IS NOT INFINITE predicates.

  • Negative infinity (-INF) sorts lower than all other values. Positive infinity (INF) sorts higher than all other values, but lower than NaN ("not a number") and the NULL value.

  • See "INF and NAN" for more information on Inf and NaN.