Skip to content

saturating_sub()

Subtract one number from another, saturating at the 32-bit integer bounds instead of overflowing

Early access 1.8.0

The saturating_sub function subtracts the second number from the first, saturating at -2,147,483,648 and 2,147,483,647 instead of overflowing.

The syntax is:

saturating_sub(
x INT,
y INT
) RETURNS INT
NameTypeDefaultRequiredDescription
xINT-An integer for y to subtract from
yINT-An integer to subtract from x
ColumnTypeDescription
saturating_subINTThe result of x - y, saturating at the numeric bounds instead of overflowing. The numeric bounds are the upper and lower bounds of the 32-bit signed integers