= Operators =
[[TracNav]]

The operators available in the pan Data Manipulation Language (DML) are very similar to those in the java or c languages.  The following tables summarize the DML operators.  The valid primitive types for each operator are indicated.  Those marked with "number" will take either long or double arguments.  In the case of binary operators, the result will be promoted to a double if the operands are mixed.  

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 (short-circuit logic) ||
|| | | || boolean || logical or (short-curcuit logic) ||
|| == || 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 ||

Operator Precedence
|| | | || lowest ||
|| && || ||
|| | || ||
|| !^ || ||
|| & || ||
|| ==, != || ||
|| <, <=, >, >= || ||
|| + (binary), - (binary) || ||
|| *, /, % || ||
|| + (unary), - (unary), !, ~ || highest ||