Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_AGGREGATE

PG_AGGREGATE

Updated at: May 15, 2019 GMT+08:00

pg_aggregate records information about aggregation 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.oid

PG_PROC OID of the aggregate function

aggtransfn

regproc

PG_PROC.oid

Transition function

aggcollectfn

regproc

PG_PROC.oid

Aggregate function

aggfinalfn

regproc

PG_PROC.oid

Final function (zero if none)

aggsortop

oid

PG_OPERATOR.oid

Associated sort operator (zero 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 out 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 out null.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel