Operator Precedence

An operator is a symbol or keyword that can be in an SQL expression. Most SQL operators are restricted in the data types of their operands and returned values. Some operators only support operands of built-in data types; others can support built-in and extended data types as operands.

The following table shows the precedence of the operators thatHCL Informix® supports, in descending (highest to lowest) order of precedence. Operators with the same precedence are listed in the same row.
Operator Precedence Example in Expression
. (membership) [ ] (substring) customer.phone [1, 3]
UNITS x UNITS DAY
+ - (unary) - y
:: (cast) NULL::TEXT
* / x / y
+ - (binary) x -y
|| (concatenation) customer.fname || customer.lname
ANY ALL SOME orders.ship_date > SOME (SELECT paid_date FROM orders)
NOT NOT y
< <= = > >= != <> x >= y
IN BETWEEN ... AND LIKE MATCHES customer.fname MATCHES y
AND x AND y
OR x OR y

See the Informix® Guide to SQL: Syntax for the syntax and semantics of these SQL operators.