Hologres is compatible with PostgreSQL and allows you to use standard PostgreSQL syntax for data development.
The following table describes the subquery functions that are supported by Hologres.
Hologres supports a subset of PostgreSQL functions. For information about how to use
the subquery functions that are supported by PostgreSQL, see Subquery Expressions.
Function | Description |
---|---|
EXISTS (subquery) | Checks whether a subquery returns rows.
Note A subquery is a SELECT statement.
|
IN (subquery) | Compares entries row by row to check whether the values produced by an expression
are included in the result returned by a subquery.
Note The number of values that the expression produces each time must be the same as the
number of columns in the result returned by the subquery.
|
NOT IN (subquery) | Compares entries row by row to check whether the values produced by an expression
are excluded from the result returned by a subquery.
Note The number of values that the expression produces each time must be the same as the
number of columns in the result returned by the subquery.
|
ANY (subquery) | Compares the values produced by an expression with the result returned by a subquery
row by row by using a specified operator.
Note The number of values that the expression produces each time must be the same as the
number of columns in the result returned by the subquery.
|
SOME (subquery) | Compares the values produced by an expression with the result returned by a subquery
row by row by using a specified operator.
Note The number of values that the expression produces each time must be the same as the
number of columns in the result returned by the subquery.
|