Property operators
Property operator is a syntax construct that describes an operator creating a property.
Property operators can be divided into context dependent and context independent.
Context dependent operators
Context dependent property operators can be part of expressions and use common parameters (context). These operators are:
- Arithmetic operators
[]
operatorACTIVE TAB
operatorAGGR
operatorCASE
operatorCLASS
operatorCONCAT
operatorEXCLUSIVE
operatorIF
operatorIF ... THEN
operatorJOIN
operatorMAX
operatorMIN
operatorMULTI
operatorOVERRIDE
operatorPARTITION
operatorGROUP
operator (withoutBY
block)PREV
operatorRECURSION
operatorSTRUCT
operatorUNGROUP
operator- Type conversion operator
AND
,OR
,NOT
,XOR
operatorsIS
,AS
operators- Change operators
- Comparison operators
Context independent operators
Context independent property operators differ from the context dependent ones in that they do not just use the upper parameters but define the parameters themselves. As a result, they cannot be part of expressions and can only be used in the =
statement and the JOIN
operator: