• 浏览分类
• 随机条目
• PgPedia 周刊
  • 2024-07-14
• 这一天...
• PostgreSQL 版本
  • PostgreSQL 18 (开发中)
  • PostgreSQL 17 (beta3)
  • PostgreSQL 16 (最新)
  • PostgreSQL 15
  • PostgreSQL 14
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11 (已结束支持)

版本图表

有用概述

有用链接

咖啡

pg_aggregate

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

按 PostgreSQL 版本定义

               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)
    

               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)
    

               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)
    

               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)
    

               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)
    

               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)
    

               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)
    

               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)
    

     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)
    

     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)
    

     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)
    

  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)
    

  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)
    

  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)
    

  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)
    

  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)
    

  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)
    

  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)
    

更改历史记录

• PostgreSQL 11 - 添加了以下列
  • aggfinalmodify (提交 4de2d4fb)
  • aggmfinalmodify (提交 4de2d4fb)
• PostgreSQL 9.6 - 添加了以下列
  • aggcombinefn (提交 a7de3dc5)
  • aggserialfn (提交 5fe5a2ce)
  • aggdeserialfn (提交 5fe5a2ce)
• PostgreSQL 9.4 - 添加了以下列
  • aggkind (提交 8d65da1f)
  • aggnumdirectargs (提交 8d65da1f)
  • aggmtransfn (提交 a9d9acbf)
  • aggminvtransfn (提交 a9d9acbf)
  • aggmfinalfn (提交 a9d9acbf)
  • aggfinalextra (提交 f0fedfe8)
  • aggmfinalextra (提交 f0fedfe8)
  • aggtransspace (提交 6cb86143)
  • aggmtransspace (提交 a9d9acbf)
  • aggmtranstype (提交 a9d9acbf)
  • aggminitval (提交 a9d9acbf)
• PostgreSQL 8.1
  • 添加了列 aggsortop (提交 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

参考

分类

反馈