Numeric Expressions

Notes

• Vertica follows the IEEE specification for floating point, including Nan.
• A NaN is not greater than and at the same time not less than anything, even itself. In other words, comparisons always return false whenever a NaN is involved.

Examples

=> SELECT CBRT('Nan'); -- cube root

cbrt

------

NaN

(1 row)

=> SELECT 'Nan' > 1.0;

?column?

----------

f

(1 row)