SYSTEM CATALOGS / SYSTEM CATALOGS
pg_aggregate
Read PG 18 manual ↗The catalog pg_aggregate stores information about aggregate functions.
- Kind
- System catalogs
- Columns in this snapshot
- 22
- Definition source
- English manual
Columns 22
| Column | Type | Description / reference |
|---|---|---|
aggfnoid | regproc | pg_proc OID of the aggregate function pg_proc.oid |
aggkind | char | Aggregate kind: n for “normal” aggregates, o for “ordered-set” aggregates, or h for “hypothetical-set” aggregates |
aggnumdirectargs | int2 | Number of direct (non-aggregated) arguments of an ordered-set or hypothetical-set aggregate, counting a variadic array as one argument. If equal to pronargs, the aggregate must be variadic and the variadic array describes the aggregated arguments as well as the final direct arguments. Always zero for normal aggregates. |
aggtransfn | regproc | Transition function pg_proc.oid |
aggfinalfn | regproc | Final function (zero if none) pg_proc.oid |
aggcombinefn | regproc | Combine function (zero if none) pg_proc.oid |
aggserialfn | regproc | Serialization function (zero if none) pg_proc.oid |
aggdeserialfn | regproc | Deserialization function (zero if none) pg_proc.oid |
aggmtransfn | regproc | Forward transition function for moving-aggregate mode (zero if none) pg_proc.oid |
aggminvtransfn | regproc | Inverse transition function for moving-aggregate mode (zero if none) pg_proc.oid |
aggmfinalfn | regproc | Final function for moving-aggregate mode (zero if none) pg_proc.oid |
aggfinalextra | bool | True to pass extra dummy arguments to aggfinalfn |
aggmfinalextra | bool | True to pass extra dummy arguments to aggmfinalfn |
aggfinalmodify | char | Whether aggfinalfn modifies the transition state value: r if it is read-only, s if the aggtransfn cannot be applied after the aggfinalfn, or w if it writes on the value |
aggmfinalmodify | char | Like aggfinalmodify, but for the aggmfinalfn |
aggsortop | oid | Associated sort operator (zero if none) pg_operator.oid |
aggtranstype | oid | Data type of the aggregate function's internal transition (state) data pg_type.oid |
aggtransspace | int4 | Approximate average size (in bytes) of the transition state data, or zero to use a default estimate |
aggmtranstype | oid | Data type of the aggregate function's internal transition (state) data for moving-aggregate mode (zero if none) pg_type.oid |
aggmtransspace | int4 | Approximate average size (in bytes) of the transition state data for moving-aggregate mode, or zero to use a default estimate |
agginitval | text | The initial value of the transition state. This is a text field containing the initial value in its external string representation. If this field is null, the transition state value starts out null. |
aggminitval | text | The initial value of the transition state for moving-aggregate mode. This is a text field containing the initial value in its external string representation. If this field is null, the transition state value starts out null. |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
aggfnoid | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggkind | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggnumdirectargs | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggtransfn | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggfinalfn | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggcombinefn | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggserialfn | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggdeserialfn | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggmtransfn | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggminvtransfn | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggmfinalfn | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggfinalextra | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggmfinalextra | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggsortop | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggtranstype | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggtransspace | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggmtranstype | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggmtransspace | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
agginitval | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggminitval | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggfinalmodify | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
aggmfinalmodify | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
Version history 5
- PG 18 → 19changed
- PG 10 → 11changed
- PG 9.6 → 10changed
- PG 9.5 → 9.6changed
- PG 9.3 → 9.4changed
Definition snapshot: english-manuals:809aefce3b143c9f0bccd2cccae… · English manual source