PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References
PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References

PostgreSQL ABS() Function



The PostgreSQL ABS() function returns the absolute value of a given number.

Syntax

ABS(number)

Parameters

number Required. Specify the number to convert to an absolute value.

Return Value

Returns the absolute value of a given number.

Example 1:

The example below shows the usage of ABS() function.

SELECT ABS(15);
Result: 15

SELECT ABS(-15);
Result: 15

SELECT ABS(25.23);
Result: 25.23

SELECT ABS(-25.23);
Result: 25.23

SELECT ABS(0);
Result: 0

SELECT ABS(10 * -2);
Result: 20

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 1-10
Data 2-5
Data 30
Data 45
Data 510

The statement given below can be used to calculate the absolute value of column x.

SELECT *, ABS(x) AS ABS_Value FROM Sample;

This will produce the result as shown below:

DataxABS_Value
Data 1-1010
Data 2-55
Data 300
Data 455
Data 51010

❮ PostgreSQL Functions