PostgreSQL power function.

Preamble

PostgreSQL power function returns the value of m, which is elevated to the n-th degree.

Syntax of the power function in PostgreSQL

power( m, n )

Parameters and function arguments

• m – Base for use in the power function.
• n – Indicator of a degree in the power function.

The power function can be used in the following PostgreSQL versions

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 power functions to see how to use a power function in PostgreSQL.
For example:

SELECT power(6, 2);
--Result: 36
SELECT power(6, -2);
--Result: 0.0277777777777778
SELECT power(5.4, 3);
--Result: 157.4640000000000000
SELECT power(0, 3);
--Result: 0
SELECT power(3, 0);
--Result: 1
SELECT power(3, 1);
--Result: 3

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.