PostgreSQL mod function.

Preamble

PostgreSQL mod function returns the residue from n divided by m.

Syntax of the mod function in PostgreSQL

mod( n, m )

Parameters and function arguments

• n – A numeric value, the rest of which you want to find.
• m – The number used to divide the number n.

Note:

• The mod function uses the formula n/m, and the remainder is what is returned.

The mod function can be used in the following versions of PostgreSQL

PostgreSQL 11, PostgreSQL 10, PostgreSQL 9.6, PostgreSQL 9.5, PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4.

Let’s look at some examples of mod functions to understand how to use a mod function in PostgreSQL.
For example:

SELECT mod(12, 5);

--Result: 2

SELECT mod(12, 0.18);

--Result: 0.12

SELECT mod(100, 3.5938);

--Result: 2.9674

PostgreSQL tutorial functions

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.