PostgreSQL abs function.

Preamble

The abs function in PostgreSQL returns the absolute value of the number.

Syntax of abs function in PostgreSQL

abs( number )

Parameters and function arguments

• number – A number for conversion to an absolute value.

The abs 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.

Consider some examples of abs functions to understand how to use the abs function in PostgreSQL.
For example:

SELECT abs(-18);

--Result: 18

SELECT abs(-18.9);

--Result: 18.9

SELECT abs(-12.57);

--Result: 12.57

SELECT abs(23.65);

--Result: 23.65

SELECT abs(30 * -1);

--Result: 30

Fun with Functions, by Example

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.