Compatible with PostgreSQL, Hologres allows you to use standard PostgreSQL syntax for data development.

The following table describes the comparison functions supported by Hologres. The functions supported by Hologres are only a subset of the PostgreSQL functions. For more information about how to use these functions, see Row and Array Comparisons in the PostgreSQL documentation.
Function Description
expressionNOT IN (values,...) Compares the value of an expression to a list of values. If the value of the expression is not a member of the given values, this function returns TRUE. Otherwise, this function returns FALSE.
expressionIN (values,...) Compares the value of an expression to a list of values. If the value of the expression is a member of the given values, this function returns TRUE. Otherwise, this function returns FALSE.