August 7, 2023

The PostgreSQL `MOD()`

function performs the modulo operation that returns the remainder after the division of the first argument by the second one.

## Syntax

The syntax of the PostgreSQL `MOD()`

function is as follows:

```
MOD(x,y)
```

## Arguments

The `MOD()`

function requires two arguments:

**1) x**

The `x`

argument is a number that 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:

```
SELECT MOD(15,4) modulus
```

The result is:

```
3
```

The following statement also returns the same result:

```
SELECT MOD(15,-4);
```

See the following statement:

```
SELECT MOD(-15,4);
```

The remainder is a negative number:

```
-3
```

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

```
SELECT MOD(-15,-4);
```

The result is:

```
-3
```

In this tutorial, you have learned how to use the PostgreSQL `MOD()`

function to find the remainder after the division of one number by another.