PG_AGGREGATE
PG_AGGREGATE records information about aggregate functions. Each entry in PG_AGGREGATE is an extension of an entry in PG_PROC. The PG_PROC entry carries the aggregate's name, input and output data types, and other information that is similar to ordinary functions.
Table 1 PG_AGGREGATE columns
PG_PROC.proname | PG_PROC proname of the aggregate function | ||
PG_PROC.proname | |||
PG_PROC.proname | |||
PG_PROC.proname | |||
PG_OPERATOR.oid | |||
PG_TYPE.oid | Data type of the aggregate function's internal transition (state) data | ||
Initial value of the transition state. This is a text column containing the initial value in its external string representation. If this column is null, the transition state value starts from null. | |||
Initial value of the collection state. This is a text column containing the initial value in its external string representation. If this column is null, the collection state value starts from null. | |||
Number of direct parameters (non-aggregation-related parameters) of the aggregate function of the ordered set aggregate type. For an aggregate function of the normal aggregate type, the value is 0. |