pg_aggregate

一个存储有关聚合函数信息的系统表

pg_aggregate 是一个系统目录表，用于存储有关聚合函数的信息。

pg_aggregate 一直存在于 PostgreSQL 中。

按 PostgreSQL 版本定义

pg_aggregate (PostgreSQL 19)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggfinalmodify   | "char"   |           | not null | 
 aggmfinalmodify  | "char"   |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     | C         |          | 
 aggminitval      | text     | C         |          | 
Indexes:
    "pg_aggregate_fnoid_index" PRIMARY KEY, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 18)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggfinalmodify   | "char"   |           | not null | 
 aggmfinalmodify  | "char"   |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     | C         |          | 
 aggminitval      | text     | C         |          | 
Indexes:
    "pg_aggregate_fnoid_index" PRIMARY KEY, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 17)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggfinalmodify   | "char"   |           | not null | 
 aggmfinalmodify  | "char"   |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     | C         |          | 
 aggminitval      | text     | C         |          | 
Indexes:
    "pg_aggregate_fnoid_index" PRIMARY KEY, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 16)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggfinalmodify   | "char"   |           | not null | 
 aggmfinalmodify  | "char"   |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     | C         |          | 
 aggminitval      | text     | C         |          | 
Indexes:
    "pg_aggregate_fnoid_index" PRIMARY KEY, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 15)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggfinalmodify   | "char"   |           | not null | 
 aggmfinalmodify  | "char"   |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     | C         |          | 
 aggminitval      | text     | C         |          | 
Indexes:
    "pg_aggregate_fnoid_index" PRIMARY KEY, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 14)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggfinalmodify   | "char"   |           | not null | 
 aggmfinalmodify  | "char"   |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     | C         |          | 
 aggminitval      | text     | C         |          | 
Indexes:
    "pg_aggregate_fnoid_index" PRIMARY KEY, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 13)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggfinalmodify   | "char"   |           | not null | 
 aggmfinalmodify  | "char"   |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     | C         |          | 
 aggminitval      | text     | C         |          | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 12)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggfinalmodify   | "char"   |           | not null | 
 aggmfinalmodify  | "char"   |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     | C         |          | 
 aggminitval      | text     | C         |          | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 11)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggfinalmodify   | "char"   |           | not null | 
 aggmfinalmodify  | "char"   |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     |           |          | 
 aggminitval      | text     |           |          | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 10)

               Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Collation | Nullable | Default 
------------------+----------+-----------+----------+---------
 aggfnoid         | regproc  |           | not null | 
 aggkind          | "char"   |           | not null | 
 aggnumdirectargs | smallint |           | not null | 
 aggtransfn       | regproc  |           | not null | 
 aggfinalfn       | regproc  |           | not null | 
 aggcombinefn     | regproc  |           | not null | 
 aggserialfn      | regproc  |           | not null | 
 aggdeserialfn    | regproc  |           | not null | 
 aggmtransfn      | regproc  |           | not null | 
 aggminvtransfn   | regproc  |           | not null | 
 aggmfinalfn      | regproc  |           | not null | 
 aggfinalextra    | boolean  |           | not null | 
 aggmfinalextra   | boolean  |           | not null | 
 aggsortop        | oid      |           | not null | 
 aggtranstype     | oid      |           | not null | 
 aggtransspace    | integer  |           | not null | 
 aggmtranstype    | oid      |           | not null | 
 aggmtransspace   | integer  |           | not null | 
 agginitval       | text     |           |          | 
 aggminitval      | text     |           |          | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 9.6)

     Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Modifiers 
------------------+----------+-----------
 aggfnoid         | regproc  | not null
 aggkind          | "char"   | not null
 aggnumdirectargs | smallint | not null
 aggtransfn       | regproc  | not null
 aggfinalfn       | regproc  | not null
 aggcombinefn     | regproc  | not null
 aggserialfn      | regproc  | not null
 aggdeserialfn    | regproc  | not null
 aggmtransfn      | regproc  | not null
 aggminvtransfn   | regproc  | not null
 aggmfinalfn      | regproc  | not null
 aggfinalextra    | boolean  | not null
 aggmfinalextra   | boolean  | not null
 aggsortop        | oid      | not null
 aggtranstype     | oid      | not null
 aggtransspace    | integer  | not null
 aggmtranstype    | oid      | not null
 aggmtransspace   | integer  | not null
 agginitval       | text     | 
 aggminitval      | text     | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 9.5)

     Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Modifiers 
------------------+----------+-----------
 aggfnoid         | regproc  | not null
 aggkind          | "char"   | not null
 aggnumdirectargs | smallint | not null
 aggtransfn       | regproc  | not null
 aggfinalfn       | regproc  | not null
 aggmtransfn      | regproc  | not null
 aggminvtransfn   | regproc  | not null
 aggmfinalfn      | regproc  | not null
 aggfinalextra    | boolean  | not null
 aggmfinalextra   | boolean  | not null
 aggsortop        | oid      | not null
 aggtranstype     | oid      | not null
 aggtransspace    | integer  | not null
 aggmtranstype    | oid      | not null
 aggmtransspace   | integer  | not null
 agginitval       | text     | 
 aggminitval      | text     | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 9.4)

     Table "pg_catalog.pg_aggregate"
      Column      |   Type   | Modifiers 
------------------+----------+-----------
 aggfnoid         | regproc  | not null
 aggkind          | "char"   | not null
 aggnumdirectargs | smallint | not null
 aggtransfn       | regproc  | not null
 aggfinalfn       | regproc  | not null
 aggmtransfn      | regproc  | not null
 aggminvtransfn   | regproc  | not null
 aggmfinalfn      | regproc  | not null
 aggfinalextra    | boolean  | not null
 aggmfinalextra   | boolean  | not null
 aggsortop        | oid      | not null
 aggtranstype     | oid      | not null
 aggtransspace    | integer  | not null
 aggmtranstype    | oid      | not null
 aggmtransspace   | integer  | not null
 agginitval       | text     | 
 aggminitval      | text     | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 9.3)

  Table "pg_catalog.pg_aggregate"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 aggfnoid     | regproc | not null
 aggtransfn   | regproc | not null
 aggfinalfn   | regproc | not null
 aggsortop    | oid     | not null
 aggtranstype | oid     | not null
 agginitval   | text    | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 9.2)

  Table "pg_catalog.pg_aggregate"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 aggfnoid     | regproc | not null
 aggtransfn   | regproc | not null
 aggfinalfn   | regproc | not null
 aggsortop    | oid     | not null
 aggtranstype | oid     | not null
 agginitval   | text    | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 9.1)

  Table "pg_catalog.pg_aggregate"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 aggfnoid     | regproc | not null
 aggtransfn   | regproc | not null
 aggfinalfn   | regproc | not null
 aggsortop    | oid     | not null
 aggtranstype | oid     | not null
 agginitval   | text    | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 9.0)

  Table "pg_catalog.pg_aggregate"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 aggfnoid     | regproc | not null
 aggtransfn   | regproc | not null
 aggfinalfn   | regproc | not null
 aggsortop    | oid     | not null
 aggtranstype | oid     | not null
 agginitval   | text    | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 8.4)

  Table "pg_catalog.pg_aggregate"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 aggfnoid     | regproc | not null
 aggtransfn   | regproc | not null
 aggfinalfn   | regproc | not null
 aggsortop    | oid     | not null
 aggtranstype | oid     | not null
 agginitval   | text    | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 8.3)

  Table "pg_catalog.pg_aggregate"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 aggfnoid     | regproc | not null
 aggtransfn   | regproc | not null
 aggfinalfn   | regproc | not null
 aggsortop    | oid     | not null
 aggtranstype | oid     | not null
 agginitval   | text    | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid)

文档: pg_aggregate

pg_aggregate (PostgreSQL 8.2)

  Table "pg_catalog.pg_aggregate"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 aggfnoid     | regproc | not null
 aggtransfn   | regproc | not null
 aggfinalfn   | regproc | not null
 aggsortop    | oid     | not null
 aggtranstype | oid     | not null
 agginitval   | text    | 
Indexes:
    "pg_aggregate_fnoid_index" UNIQUE, btree (aggfnoid oid_ops)

文档: pg_aggregate

变更历史

PostgreSQL 11 - 添加了以下列
- aggfinalmodify (commit 4de2d4fb)
- aggmfinalmodify (commit 4de2d4fb)
PostgreSQL 9.6 - 添加了以下列
- aggcombinefn (commit a7de3dc5)
- aggserialfn (commit 5fe5a2ce)
- aggdeserialfn (commit 5fe5a2ce)
PostgreSQL 9.4 - 添加了以下列
- aggkind (commit 8d65da1f)
- aggnumdirectargs (commit 8d65da1f)
- aggmtransfn (commit a9d9acbf)
- aggminvtransfn (commit a9d9acbf)
- aggmfinalfn (commit a9d9acbf)
- aggfinalextra (commit f0fedfe8)
- aggmfinalextra (commit f0fedfe8)
- aggtransspace (commit 6cb86143)
- aggmtransspace (commit a9d9acbf)
- aggmtranstype (commit a9d9acbf)
- aggminitval (commit a9d9acbf)
PostgreSQL 8.1
- 列 aggsortop 已添加 (commit 2e7a6889)
PostgreSQL 7.2
- 列 aggname 已移除
- 列 aggowner 已移除
- 列 aggbasetype 已移除
- 列 aggfinaltype 已移除
- 列 aggfnoid 已添加

示例

postgres=# SELECT * FROM pg_aggregate WHERE aggfnoid::TEXT ='pg_catalog.count' LIMIT 1\x\g\x
Expanded display is on.
-[ RECORD 1 ]----+-----------------
aggfnoid         | pg_catalog.count
aggkind          | n
aggnumdirectargs | 0
aggtransfn       | int8inc_any
aggfinalfn       | -
aggcombinefn     | int8pl
aggserialfn      | -
aggdeserialfn    | -
aggmtransfn      | int8inc_any
aggminvtransfn   | int8dec_any
aggmfinalfn      | -
aggfinalextra    | f
aggmfinalextra   | f
aggfinalmodify   | r
aggmfinalmodify  | r
aggsortop        | 0
aggtranstype     | 20
aggtransspace    | 0
aggmtranstype    | 20
aggmtransspace   | 0
agginitval       | 0
aggminitval      | 0

参考资料

PostgreSQL 文档: pg_aggregate

反馈

提交关于“pg_aggregate”的任何评论、建议或更正请 在此处进行。

版本图表

实用概述

有用链接

咖啡

目录

pg_aggregate

按 PostgreSQL 版本定义

pg_aggregate (PostgreSQL 19)

pg_aggregate (PostgreSQL 18)

pg_aggregate (PostgreSQL 17)

pg_aggregate (PostgreSQL 16)

pg_aggregate (PostgreSQL 15)

pg_aggregate (PostgreSQL 14)

pg_aggregate (PostgreSQL 13)

pg_aggregate (PostgreSQL 12)

pg_aggregate (PostgreSQL 11)

pg_aggregate (PostgreSQL 10)

pg_aggregate (PostgreSQL 9.6)

pg_aggregate (PostgreSQL 9.5)

pg_aggregate (PostgreSQL 9.4)

pg_aggregate (PostgreSQL 9.3)

pg_aggregate (PostgreSQL 9.2)

pg_aggregate (PostgreSQL 9.1)

pg_aggregate (PostgreSQL 9.0)

pg_aggregate (PostgreSQL 8.4)

pg_aggregate (PostgreSQL 8.3)

pg_aggregate (PostgreSQL 8.2)

变更历史

示例

参考资料

分类

反馈