Specify operator precedence for SQL queries.
n is either 1 or 0. The default value is 1.
When ANSIPrecedence is enabled (n = 1), InterSystems SQL uses ANSI precedence of arithmetic operators. If ANSIPrecedence is disabled (n = 0), InterSystems SQL executes arithmetic expressions in strict left-to-right order. This is an instance-wide configuration setting.
When ANSI precedence is configured, the “*”, “\”, “/”, and “#” operators have a higher precedence than the “+”, “-”, and “||” operators. Operators with a higher precedence are executed before operators with a lower precedence. You can use parentheses to override precedence when desired.
For further details, refer to the Operator Precedence section of the Using InterSystems SQL Guide.