MOD, %¶
Calculates the modulu (remainder) of x divided by y.
This function can be also be called with an infix operator, x % y.
Syntax¶
modulu ::= MOD( expr1, expr2 )
| expr1 % expr2
Arguments¶
Parameter |
Description |
|---|---|
|
Integer expression (dividend) |
|
Integer expression (divisor) |
Returns¶
Always returns a integer result.
Notes¶
If the input value is NULL, the result is NULL.
Both inputs are expected to be integers
Examples¶
Using the MOD function¶
numbers=> SELECT MOD(11,-5), MOD(8,5), MOD(1,1);
mod | mod0 | mod1
----+------+-----
1 | 3 | 0
Using the infix operator¶
numbers=> SELECT 11 % -5, 8 % 5, 1 % 1;
?column? | ?column?0 | ?column?1
---------+-----------+----------
1 | 3 | 0