| Informix Guide to SQL: Reference Data Types |
|
|
An operator is a symbol or keyword that is used for operations on data types. Some operators only support built in data types; other operators support both built-in and extended data types.
The following table shows the precedence of the operators that Informix database servers support, in descending order of precedence. Operators with the same precedence are listed in the same row.
| Operator Precedence |
|---|
| UNITS |
| + (unary) -(unary) |
| :: |
| * / |
| + - |
| || |
| ANY ALL SOME |
| NOT |
| < <= = > >= != <> IN BETWEEN LIKE MATCHES |
| AND |
| OR |