saturating_sub_pos()

Subtract one number from another, saturating at 0 for the minimum bound

Early access Since 1.8.0

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

Arguments

The syntax is:

saturating_sub_pos(
  x INT,
  y INT
) RETURNS INT

Name	Type	Default	Required	Description
x	INT	-	✔	An integer for y to subtract from
y	INT	-	✔	An integer to subtract from x

Returns

Column	Type	Description
saturating_sub_pos	INT	The result of x - y, saturating at 0 for the minimum bound