Float32, Float64

    • - float
    • Float64 - double
    • Computations with floating-point numbers might produce a rounding error.
    1. ┌───────minus(1, 0.9)─┐
    2. │ 0.09999999999999998 │
    • The result of the calculation depends on the calculation method (the processor type and architecture of the computer system).
    • Floating-point calculations might result in numbers such as infinity () and “not-a-number” (NaN). This should be taken into account when processing the results of calculations.
    • When parsing floating-point numbers from text, the result might not be the nearest machine-representable number.

    NaN and Inf

    • Inf – Infinity.
    1. SELECT 0.5 / 0
    • -Inf – Negative infinity.
    1. SELECT -0.5 / 0
    2. └─────────────────┘
    • NaN – Not a number.
    1. ┌─divide(0, 0)─┐
    2. │          nan │
    3. └──────────────┘
    1. See the rules for `NaN` sorting in the section [ORDER BY clause](../sql_reference/statements/select/order-by.md).