Compatible with PostgreSQL, Hologres allows you to use standard PostgreSQL syntax for data development.
The following table describes the ordered-set aggregate 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 Aggregate Functions in the PostgreSQL documentation.
Function | Description | Example | Result |
---|---|---|---|
GROUPING(args...) | Returns a integer bit mask indicating the arguments that are not included in the current grouping set. | grouping(c1, c2) | N/A |