This page in other versions: Unsupported versions: 6.4

Numerical Operators

Table 9-3. Postgres Numerical Operators

Operator Description Usage
! Factorial 3 !
!! Factorial (left operator) !! 3
% Modulo 5 % 4
% Truncate % 4.5
* Multiplication 2 * 3
+ Addition 2 + 3
- Subtraction 2 - 3
/ Division 4 / 2
: Natural Exponentiation : 3.0
; Natural Logarithm (; 5.0)
@ Absolute value @ -5.0
^ Exponentiation 2.0 ^ 3.0
|/ Square root |/ 25.0
||/ Cube root ||/ 27.0
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group