Conditional operators for opaque data types

The database server supports the following relational operators on an opaque data type in the conditional clause of SQL statements:
  • The IS and IS NOT operators
  • The IN operator if the equal() function has been defined
  • The BETWEEN operator if the compare() function has been defined
Tip: The database server also uses the compare() function as the support function for the default B-tree operator class. For more information, see Extensions of the btree_ops operator class.

For more information about the conditional clause, see the Condition segment in the HCL OneDB™ Guide to SQL: Syntax. For more information about the compare() function, see Comparison function for opaque data types.