diff options
Diffstat (limited to 'pgsql_mib_pieces/pg_aggregate.tbldef')
| -rw-r--r-- | pgsql_mib_pieces/pg_aggregate.tbldef | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/pgsql_mib_pieces/pg_aggregate.tbldef b/pgsql_mib_pieces/pg_aggregate.tbldef new file mode 100644 index 0000000..9d4a71a --- /dev/null +++ b/pgsql_mib_pieces/pg_aggregate.tbldef @@ -0,0 +1,7 @@ +pg_aggregate "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.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." "A pg_aggregate entry" pgsqlCatalogTables 1 "pgsnmpdConnID, rdbmsDbIndex, pgsqlPgAggregateAggfnoid" +"aggfnoid" "INTEGER" "pg_proc OID of the aggregate function" +"aggtransfn" "INTEGER" "Transition function" +"aggfinalfn" "INTEGER" "Final function (zero if none)" +"aggsortop" "INTEGER" "Associated sort operator (zero if none)" +"aggtranstype" "INTEGER" "Data type of the aggregate function's internal transition (state) data" +"agginitval" "DisplayString" "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" |