Numerical Operators

PostgreSQL
Prev	Chapter 4. Operators	Next

Numerical Operators

Table 4-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
@	Absolute value	@ -5.0
^	Exponentiation	2.0 ^ 3.0
\|/	Square root	\|/ 25.0
\|\|/	Cube root	\|\|/ 27.0

Note: Two operators, ":" and ";", are now deprecated and will be removed in the next release. Use the equivalent functions exp() and ln() instead.

Prev	Home	Next
General Operators	Up	Geometric Operators