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
AlphaCodingSkills
AlphaCodingSkills Android App
Facebook Page Twitter Page LinkedIn Page
Learning Tutorials
Learning Tutorials
Useful Links
Python Libraries
About Us  |  Privacy Policy  |  Contact Us
AlphaCodingSkills is a online learning portal that provides tutorials on Python, Java, C++, C, C#, PHP, R, Ruby, Rust, Scala, Swift, Perl, SQL, Data Structures and Algorithms. Tutorials, examples, references and content of the website are reviewed and simplified continuously to improve comprehensibility and eliminate any possible error. We use cookies to ensure best browsing experience on our website. While using this website, you acknowledge to have read and accepted our cookie and privacy policy.