Functions and operators
Description
PQL provides a wide variety of functions and operators that can be used within a query.
This sections contains all available functions and operators. In contrast to operators, functions obey a strict syntax of listing function parameters - especially the more complex ones like CASE WHEN.
Operator precedence
If an expression contains more than one operator, the operators are evaluated in order of operator precedence. To influence the evaluation order you can use parentheses which have the highest operator precedence and are evaluated first. Operators with the same operator precedence are evaluated from left to right.
Expressions
Precedence | Operator | Operation |
|---|---|---|
Highest | () | parentheses |
+, - | unary positive and negative operator | |
*, /, % | multiplication, division, modulo | |
+, - | addition, subtraction | |
Lowest | || | concatenation |
Logical expressions
Precedence | Operator | Operation |
|---|---|---|
Highest | (), NOT() | parentheses, parentheses with logical negation |
AND | conjunction | |
Lowest | OR | disjunction |