HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

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

Name Type Reference Description
aggfnoid regproc PG_PROC.proname PG_PROC proname of the aggregate function
aggtransfn regproc PG_PROC.proname Transition function
aggcollectfn regproc PG_PROC.proname Collect function
aggfinalfn regproc PG_PROC.proname Final function (0 if none)
aggsortop oid PG_OPERATOR.oid Associated sort operator (0 if none)
aggtranstype oid PG_TYPE.oid Data type of the aggregate function's internal transition (state) data
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:
- n: normal aggregate
- o: ordered set aggregate
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.
Copyright © 2011-2024 www.enmotech.com All rights reserved.