Sybase CEP expressions support a variety of numeric, non-numeric, and logical operator types.
|
Operator Type |
Description |
|---|---|
|
Arithmetic |
addition (+), subtraction (-), multiplication (*), division (/), exponentiation (^), modulo (mod) |
|
String |
concatenation operator (||) |
|
Comparison |
equality (=), inequality (!= or <>), greater than (>), less than (<), greater than or equal to (>=), less than or equal to (<=), wildcard string comparisons (LIKE, REGEXP_LIKE), null comparisons (IS NULL, IS NOT NULL) |
|
Logical |
AND, OR, XOR, NOT |
|
Grouping |
(...) |
CCL operators are executed following a defined precedence order which is similar to the order used in ANSI SQL (for instance, multiplication and division are always performed before addition and subtraction, and all arithmetic is performed before any comparisons). Parentheses can always be used to group the operations in an expression in a different order (operators inside parentheses are performed before operators outside the parentheses).
For a complete explanation of operators and the precedence order used by CCL, please see Sybase CEP CCL Reference.