Operators

The operators available in the pan data manipulation language are very similar to those in the C language.

Unary DML Operators

+	number	preserves sign of argument
-	number	changes sign of argument
~	long	bit-wise not
!	boolean	logical not

Binary DML Operators

+	number	addition
+	string	string concatenation
-	number	subtraction
*	number	multiplication
/	number	division
%	long	modulus
&	long	bit-wise and
|	long	bit-wise or
	long	bit-wise exclusive or
&&	boolean	logical and
#!html |‍|	boolean	logical or
==	number	equal
==	string	lexical equal
!=	number	not equal
!=	string	lexical not equal
>	number	greater-than
>	string	lexical greater-than
>=	number	greater-than-or-equal
>=	string	lexical greater-than-or-equal
<	number	less-than
<	string	lexical less-than
<=	number	less-than-or-equal
<=	string	lexical less-than-or-equal