Skip to content

ABS

Return the absolute value of a number.

ABS(number)

Alternatively, you can use @ number (no parentheses around the number).

For example:

premdb=# SELECT ABS(-5);
 abs 
-----
   5
(1 row)
premdb=# SELECT @ -5;
 ?column? 
----------
       5
(1 row)

The following example returns the absolute value for the result of an expression. The result represents the difference between the two numbers in the ftscore column.

premdb=# SELECT ftscore, 
ABS((SUBSTR(ftscore,1,1)::INT)-(SUBSTR(ftscore,3,1)::INT)) 
FROM match LIMIT 25;
 ftscore | abs 
---------+-----
 0-1     |   1
 0-1     |   1
 2-1     |   1
 3-0     |   3
 3-0     |   3
 2-0     |   2
 0-0     |   0
 0-0     |   0
 0-1     |   1
 1-0     |   1
 0-1     |   1
...

Parent topic:Mathematical Functions