PostgreSQL ABSOLUTE VALUE

Postgresql absolute operator

Returns an absolute value for a give number. Similar to ABS() function.

Syntax absolute operator

a is a number.

@ a

Example 1

postgres=# SELECT @ -4  a4;
 a4 
----
  4
(1 row)

Example 2

postgres=# SELECT @ -44.04  a4;
  a4   
-------
 44.04
(1 row)

Related Links

• Postgresql Mathematical Operators
• Learning PostgreSQL
• Tutorial Home

---

1. addition(+)
2. subtraction(-)
3. multiplication(*)
4. division(/)

1. modulo(%)
2. exponentiation(^)
3. square root(|/)
4. cube root(||/)

1. factorial(!)
2. absolute value(@)
3. bitwise AND(&)
4. bitwise OR(|)

1. bitwise XOR(#)
2. bitwise NOT(~)
3. bitwise shift left(<<)
4. bitwise shift right(>>)