↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 6.4
Historical version. PostgreSQL 6.4 reached end of support in October 2003. See the current manual for supported releases.
PostgreSQL
Prev Chapter 9. Operators Next

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
Prev Home Next
General Operators Up Geometric Operators

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.