MOD
Returns the remainder of dividing one number by another.
PostgreSQL 17.5
MOD(dividend, divisor)Parameters
- dividendinteger | numeric
- Dividend
- divisorinteger | numeric
- Divisor
Return value
The remainder of the same type with the sign of the dividend: MOD(-7, 3) = -1; dividing by 0 is an error
Examples
Remainder of a division
PostgreSQL 17.5
SELECT MOD(7, 3);Remainder of a negative number
PostgreSQL 17.5
SELECT MOD(-7, 3);Table rows with an even id
PostgreSQL 17.5
SELECT member_id,
member_name
FROM FamilyMembers
WHERE MOD(member_id, 2) = 0;Details
Instead of MOD you can use the % operator: 7 % 3 = 1. There is no version for double precision: MOD(7.5::float8, 2) causes an error, while with numeric it works — MOD(7.5, 2) = 1.5.