Relational Operators
Relational operators specify how c-treeSQL compares expressions in basic and quantified predicates.
Syntax
relop ::
=
| <> | != | ^=
| <
| <=
| >
| >=
Relational Operator
|
Predicate
|
=
|
True if the two expressions are equal.
|
<> | != | ^=
|
True if the two expressions are not equal. The operators != and ^= are equivalent to <>.
|
<
|
True if the first expression is less than the second expression.
|
<=
|
True if the first expression is less than or equal to the second expression
|
>
|
True if the first expression is greater than the second expression.
|
>=
|
True if the first expression is greater than or equal to the second expression.
|
Refer to "Basic Predicate" and "Quantified Predicate" for more information.
|
