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.
Name | Type | Reference | Description |
|---|---|---|---|
aggfnoid | regproc | proname in PG_PROC | PG_PROC proname of the aggregate function |
aggtransfn | regproc | proname in PG_PROC | Transition function |
aggcollectfn | regproc | proname in PG_PROC | Collect function |
aggfinalfn | regproc | proname in PG_PROC | Final function (0 if none) |
aggsortop | oid | oid in PG_OPERATOR | Associated sort operator (0 if none) |
aggtranstype | oid | oid in PG_TYPE | Data type of the aggregate function's internal transition (state) data The possible values and their meanings are defined by the types in pg_type.h. The main two types are polymorphic (isPolymorphicType) and non-polymorphic. |
agginitval | text | - | 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. |
agginitcollect | text | - | 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. |
aggkind | "char" | - | Type of the aggregate function:
|
aggnumdirectargs | smallint | - | 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
