Home | Previous Page | Next Page   Data Types >

Operator Precedence

An operator is a symbol or keyword that can appear 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 that Informix database servers support, 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 IBM Informix: Guide to SQL Syntax for the syntax and semantics of these SQL operators.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]