/ [division]

All functions > MATH > / [division]

Divides the left-hand number by the right-hand number, producing a DOUBLE result.

Syntax

left / right  ·  DIVIDE(left, right)

left / right  ·  DIVIDE(left, right)

Notes

• Both operands are promoted for division; the result type is DOUBLE
• Returns NULL if either operand is NULL
• Division by zero is an error; use TRY_DIVIDE for a NULL result when the divisor may be zero
• For type-preserving division (including integer truncation), use DIVIDE_TYPE (//)

Related Functions

• DIVIDE()

Examples

/ — floating-point division

SELECT
    -- Quotient as DOUBLE
    f1 := 10e0 / 3e0,
    -- Exact division
    f2 := 15e0 / 5e0
;

/ — edge cases

SELECT
    -- Negative dividend
    f1 := -8e0 / 4e0
;