| Postgres-XC 1.2devel Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 47. System Catalogs | Fast Forward | Next |
Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.
The catalog pg_aggregate stores information about
aggregate functions. An aggregate function is a function that
operates on a set of values (typically one column from each row
that matches a query condition) and returns a single value computed
from all these values. Typical aggregate functions are
sum, count, and
max. 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 47-2. pg_aggregate Columns
| Name | Type | References | 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 | Collection function (Only for Postgres-XC> |
| 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 and collection (state) data (Revised for Postgres-XC) |
| 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. | |
| agginitcollect | text | The initial value of the collection state. This is a text field containing the initial value in its external string representation. If this field is null, the collection state value starts out null. (Only for Postgres-XC) |
New aggregate functions are registered with the CREATE AGGREGATE command. See Section 34.10 for more information about writing aggregate functions and the meaning of the transition functions, etc.