Mathematical Operators

Mathematical operators are provided for many data types.

Operator	Description	Example	Result
+	addition	2 + 3	5
-	subtraction	2 - 3	-1
*	multiplication	2 * 3	6
/	division (integer division truncates results)	4 / 2	2
%	modulo (remainder)	5 % 4	1
^	exponentiation	2.0 ^ 3.0	8
\|/	square root	\|/ 25.0	5
\|\|/	cube root	\|\|/ 27.0	3
!	factorial	5 !	120
!!	factorial (prefix operator)	!! 5	120
@	absolute value	@ -5.0	5
&	bitwise AND	91 & 15	11
\|	bitwise OR	32 \| 3	35
#	bitwise XOR	17 # 5	20
~	bitwise NOT	~1	-2
<<	bitwise shift left	1 << 4	16
>>	bitwise shift right	8 >> 2	2

Notes

The bitwise operators work only on integer data types, whereas the others are available for all numeric data types.
Vertica supports the use of the factorial operators on positive and negative floating point (DOUBLE PRECISION) numbers as well as integers. For example:
=> select 4.98!;

?column?

------------------

115.978600750905

(1 row)

Factorial is defined as z! = gamma(z+1) for all complex numbers z. See the Handbook of Mathematical Functions (1964) Section 6.1.5.