Operators Operator

/

Operands & returns

3 overloads

Operator

Overload link	`left`	`right`	Returns
#01	`DOUBLE`	`DOUBLE`	`DOUBLE`
#02	`FLOAT`	`FLOAT`	`FLOAT`
#03	`INTERVAL`	`DOUBLE`	`INTERVAL`

Used in larger rewrites 2

These examples use / as one part of a larger SQL translation.

SAFE_DIVIDE(x + 1, 2 * y)

In DuckDB

CASE WHEN (2 * y) <> 0 THEN (x + 1) / (2 * y) ELSE NULL END

DIV0NULL(a - b, c - d)

In DuckDB

CASE WHEN (c - d) = 0 OR (c - d) IS NULL THEN 0 ELSE (a - b) / (c - d) END