Informix Guide to SQL: Reference</i>;

Informix Guide to SQL: Reference
Chapter 2: Data Types

Home Contents Index Master Index New Book

Operator Precedence

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 Universal Server supports. The table shows operators in decreasing order of precedence from the top. Operators with the same precedence are shown in the same row.

Operator Precedence
UNITS

+ (unary) -(unary)

::

* /

+ -

||

ANY ALL SOME

NOT

< <= = > >= != <> IN BETWEEN LIKE MATCHES

AND

OR

Informix Guide to SQL: Reference, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.