PostgreSQL MOD Function

The PostgreSQL MOD() function performs the modulo operation that returns the remainder after division of the first argument by the second one.

Syntax

The syntax of the PostgreSQL MOD() function is as follows:

Arguments

The MOD() function requires two arguments:

1) x

The x argument is a number which is divided by the second one.

2) y

The y argument is the divisor.

y must not be zero (0), otherwise, the function will issue the division by zero error.

Return Value

The MOD() function returns a number whose data type is the same as the input argument.

Examples

The following example shows how to use the MOD() function to get the remainder of two integers:

The result is:

The following statement also returns the same result:

See the following statement:

The remainder is a negative number:

Similarly, the following statement returns the same negative remainder number:

The result is:

In this tutorial, you have learned how to use the PostgreSQL MOD() function to find the remainder after division of one number by another.