Operators

Which symbols are used to represent operators in expressions depends on whether NPS compatibility mode is being used.

Whether NPS compatibility mode is being used depends on the setting of the SQL_COMPAT global variable:
  • When SQL_COMPAT='NPS', the operators ^ and ** are both interpreted as the exponential operator, and the operator # is interpreted as bitwise XOR.
  • Otherwise, the operator ^ is interpreted as bitwise XOR, the operator ** is interpreted as the exponential operator, and the operator # has no meaning (see Expressions).