FUNC - 数学函数

标识聚合函数:ID生成器,各类聚合函数,摘要函数,数组处理函数,数学函数,统计量,伪随机,等等

标识聚合函数:ID生成器,各类聚合函数,摘要函数,数组处理函数,数学函数,统计量,伪随机,等等

共有 47 个扩展包,包含 47 个扩展。

扩展 版本 许可证 语言 描述
pg_idkit pg_idkit 0.4.0 Apache-2.0 Rust 生成各式各样的唯一标识符:UUIDv6, ULID, KSUID
pgx_ulid pgx_ulid 0.2.2 MIT Rust ULID数据类型与函数
pg_uuidv7 pg_uuidv7 1.7.0 MPL-2.0 C UUIDv7 支持
permuteseq permuteseq 1.2.2 PostgreSQL C 伪随机数ID置换生成器
pg_hashids pg_hashids 1.3 MIT C 加盐将整型ID转为短字符串ID
sequential_uuids sequential_uuids 1.0.3 MIT C 生成连续生成的UUID
typeid pg_typeid 0.3.0 MIT Rust PG原生TypeID类型与函数
snowflake snowflake 2.4 PostgreSQL C Snowflake 风格 64 位 ID 生成与序列工具
topn topn 2.7.0 AGPL-3.0 C top-n JSONB 的类型
quantile quantile 1.1.8 BSD 2-Clause C Quantile聚合函数
lower_quantile lower_quantile 1.0.3 BSD 2-Clause C Lower Quantile 聚合函数
count_distinct count_distinct 3.0.2 BSD 2-Clause C COUNT(DISTINCT …) 聚合的替代方案
omnisketch omnisketch 1.0.2 PostgreSQL C 实现OmniSketch数据结构,实现近似摘要聚合
ddsketch ddsketch 1.0.1 PostgreSQL C 实现DDSketch数据结构,实现在线的Quantile聚合
vasco vasco 0.1.0 GPL-3.0 C 使用MIC发现数据中隐含的关联
xicor pgxicor 0.1.0 GPL-3.0 C 在PG中计算XI相关系数
weighted_statistics pg_weighted_statistics 1.0.0 PostgreSQL C 针对稀疏数据的高性能加权统计量计算
tdigest tdigest 1.4.3 Apache-2.0 C tdigest 聚合函数
first_last_agg first_last_agg 0.1.4 PostgreSQL C first() 与 last() 聚合函数
extra_window_functions extra_window_functions 1.0 PostgreSQL C 额外的窗口函数
floatvec floatvec 1.1.1 MIT C 数组类型数学运算扩展
aggs_for_vecs aggs_for_vecs 1.4.1 MIT C 针对数组类型的聚合函数集合扩展
aggs_for_arrays aggs_for_arrays 1.3.3 MIT C 计算数组聚合统计值的函数包
pg_csv pg_csv 1.0.1 MIT C 灵活的CSV聚合处理函数
arraymath pg_arraymath 1.1 MIT C 数组逐元素数学运算符包
pg_math pg_math 1.1.0 GPL-3.0 C 使用GSL库的数学统计函数
random pg_random 2.0.0 PostgreSQL C 随机数生成器
base36 pg_base36 1.0.0 MIT C Base36编码解码扩展
base62 pg_base62 0.0.1 MIT C Base62编码解码扩展
pg_base58 pg_base58 0.0.1 MIT Rust Base58 编码/解码函数
financial pg_financial 1.0.1 PostgreSQL C 金融领域聚合函数
convert pg_convert 0.1.0 MIT Rust 用于空间里程等的公英制转换函数
refint refint 1.0 PostgreSQL C 实现引用完整性的函数
autoinc autoinc 1.0 PostgreSQL C 用于自动递增字段的函数
insert_username insert_username 1.0 PostgreSQL C 用于跟踪谁更改了表的函数
moddatetime moddatetime 1.0 PostgreSQL C 跟踪最后修改时间
tsm_system_time tsm_system_time 1.0 PostgreSQL C 接受毫秒数限制的 TABLESAMPLE 方法
dict_xsyn dict_xsyn 1.0 PostgreSQL C 用于扩展同义词处理的文本搜索字典模板
tsm_system_rows tsm_system_rows 1.0 PostgreSQL C 接受行数限制的 TABLESAMPLE 方法
tcn tcn 1.0 PostgreSQL C 用触发器通知变更
uuid-ossp uuid-ossp 1.1 PostgreSQL C 生成通用唯一标识符(UUIDs)
btree_gist btree_gist 1.7 PostgreSQL C 用GiST索引常见数据类型
btree_gin btree_gin 1.3 PostgreSQL C 用GIN索引常见数据类型
intarray intarray 1.5 PostgreSQL C 1维整数数组的额外函数、运算符和索引支持
intagg intagg 1.1 PostgreSQL C 整数聚合器和枚举器(过时)
dict_int dict_int 1.0 PostgreSQL C 用于整数的文本搜索字典模板
unaccent unaccent 1.1 PostgreSQL C 删除重音的文本搜索字典

pg_idkit - 0.4.0

生成各式各样的唯一标识符:UUIDv6, ULID, KSUID

Extension Website Attributes
Package pg_idkit
RPM pg_idkit_$v DDL
DEB postgresql-$v-pg-idkit LIB
Language Rust
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pgx_ulid - 0.2.2

ULID数据类型与函数

Extension Website Attributes
Package pgx_ulid
RPM pgx_ulid_$v DDL
DEB postgresql-$v-pgx-ulid LIB
Language Rust
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_uuidv7 - 1.7.0

UUIDv7 支持

Extension Website Attributes
Package pg_uuidv7
RPM pg_uuidv7_$v DDL
DEB postgresql-$v-pg-uuidv7 LIB
Language C
License MPL-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

permuteseq - 1.2.2

伪随机数ID置换生成器

Extension Website Attributes
Package permuteseq
RPM permuteseq_$v DDL
DEB postgresql-$v-permuteseq LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_hashids - 1.3

加盐将整型ID转为短字符串ID

Extension Website Attributes
Package pg_hashids
RPM pg_hashids_$v DDL
DEB postgresql-$v-pg-hashids LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

sequential_uuids - 1.0.3

生成连续生成的UUID

Extension Website Attributes
Package sequential_uuids
RPM sequential_uuids_$v DDL
DEB postgresql-$v-sequential-uuids LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

typeid - 0.3.0

PG原生TypeID类型与函数

Extension Website Attributes
Package pg_typeid
RPM pg_typeid_$v DDL
DEB postgresql-$v-typeid LIB
Language Rust
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

snowflake - 2.4

Snowflake 风格 64 位 ID 生成与序列工具

Extension Website Attributes
Package snowflake
RPM snowflake_$v DDL
DEB pgedge-$v-snowflake LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

topn - 2.7.0

top-n JSONB 的类型

Extension Website Attributes
Package topn
RPM topn_$v DDL
DEB postgresql-$v-topn LIB
Language C
License AGPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

quantile - 1.1.8

Quantile聚合函数

Extension Website Attributes
Package quantile
RPM quantile_$v DDL
DEB postgresql-$v-quantile LIB
Language C
License BSD 2-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

lower_quantile - 1.0.3

Lower Quantile 聚合函数

Extension Website Attributes
Package lower_quantile
RPM lower_quantile_$v DDL
DEB postgresql-$v-lower-quantile LIB
Language C
License BSD 2-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

count_distinct - 3.0.2

COUNT(DISTINCT …) 聚合的替代方案

Extension Website Attributes
Package count_distinct
RPM count_distinct_$v DDL
DEB postgresql-$v-count-distinct LIB
Language C
License BSD 2-Clause
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

omnisketch - 1.0.2

实现OmniSketch数据结构,实现近似摘要聚合

Extension Website Attributes
Package omnisketch
RPM omnisketch_$v DDL
DEB postgresql-$v-omnisketch LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

ddsketch - 1.0.1

实现DDSketch数据结构,实现在线的Quantile聚合

Extension Website Attributes
Package ddsketch
RPM ddsketch_$v DDL
DEB postgresql-$v-ddsketch LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

vasco - 0.1.0

使用MIC发现数据中隐含的关联

Extension Website Attributes
Package vasco
RPM vasco_$v DDL
DEB postgresql-$v-vasco LIB
Language C
License GPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

xicor - 0.1.0

在PG中计算XI相关系数

Extension Website Attributes
Package pgxicor
RPM pgxicor_$v DDL
DEB postgresql-$v-pgxicor LIB
Language C TRUST
License GPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

weighted_statistics - 1.0.0

针对稀疏数据的高性能加权统计量计算

Extension Website Attributes
Package pg_weighted_statistics
RPM pg_weighted_statistics_$v DDL
DEB postgresql-$v-weighted-statistics LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

tdigest - 1.4.3

tdigest 聚合函数

Extension Website Attributes
Package tdigest
RPM tdigest_$v DDL
DEB postgresql-$v-tdigest LIB
Language C
License Apache-2.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

first_last_agg - 0.1.4

first() 与 last() 聚合函数

Extension Website Attributes
Package first_last_agg
RPM first_last_agg_$v DDL
DEB postgresql-$v-first-last-agg LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

extra_window_functions - 1.0

额外的窗口函数

Extension Website Attributes
Package extra_window_functions
RPM extra_window_functions_$v DDL
DEB postgresql-$v-extra-window-functions LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el9181716151817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

floatvec - 1.1.1

数组类型数学运算扩展

Extension Website Attributes
Package floatvec
RPM floatvec_$v DDL
DEB postgresql-$v-floatvec LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

aggs_for_vecs - 1.4.1

针对数组类型的聚合函数集合扩展

Extension Website Attributes
Package aggs_for_vecs
RPM aggs_for_vecs_$v DDL
DEB postgresql-$v-aggs-for-vecs LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

aggs_for_arrays - 1.3.3

计算数组聚合统计值的函数包

Extension Website Attributes
Package aggs_for_arrays
RPM aggs_for_arrays_$v DDL
DEB postgresql-$v-aggs-for-arrays LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_csv - 1.0.1

灵活的CSV聚合处理函数

Extension Website Attributes
Package pg_csv
RPM pg_csv_$v DDL
DEB postgresql-$v-pg-csv LIB
Language C TRUST
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

arraymath - 1.1

数组逐元素数学运算符包

Extension Website Attributes
Package pg_arraymath
RPM pg_arraymath_$v DDL
DEB postgresql-$v-pg-arraymath LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_math - 1.1.0

使用GSL库的数学统计函数

Extension Website Attributes
Package pg_math
RPM pg_math_$v DDL
DEB postgresql-$v-pg-math LIB
Language C
License GPL-3.0
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

random - 2.0.0

随机数生成器

Extension Website Attributes
Package pg_random
RPM pg_random_$v DDL
DEB postgresql-$v-random LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

base36 - 1.0.0

Base36编码解码扩展

Extension Website Attributes
Package pg_base36
RPM pg_base36_$v DDL
DEB postgresql-$v-base36 LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

base62 - 0.0.1

Base62编码解码扩展

Extension Website Attributes
Package pg_base62
RPM pg_base62_$v DDL
DEB postgresql-$v-base62 LIB
Language C
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

pg_base58 - 0.0.1

Base58 编码/解码函数

Extension Website Attributes
Package pg_base58
RPM pg_base58_$v DDL
DEB postgresql-$v-pg-base58 LIB
Language Rust
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

financial - 1.0.1

金融领域聚合函数

Extension Website Attributes
Package pg_financial
RPM pg_financial_$v DDL
DEB postgresql-$v-pg-financial LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

convert - 0.1.0

用于空间里程等的公英制转换函数

Extension Website Attributes
Package pg_convert
RPM pg_convert_$v DDL
DEB postgresql-$v-convert LIB
Language Rust TRUST
License MIT
OS/Archx86_64aarch64
el818171615141817161514
el918171615141817161514
el1018171615141817161514
d1218171615141817161514
d1318171615141817161514
u2218171615141817161514
u2418171615141817161514

refint - 1.0

实现引用完整性的函数

Extension Website Attributes
Package refint
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

autoinc - 1.0

用于自动递增字段的函数

Extension Website Attributes
Package autoinc
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

insert_username - 1.0

用于跟踪谁更改了表的函数

Extension Website Attributes
Package insert_username
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

moddatetime - 1.0

跟踪最后修改时间

Extension Website Attributes
Package moddatetime
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

tsm_system_time - 1.0

接受毫秒数限制的 TABLESAMPLE 方法

Extension Website Attributes
Package tsm_system_time
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

dict_xsyn - 1.0

用于扩展同义词处理的文本搜索字典模板

Extension Website Attributes
Package dict_xsyn
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

tsm_system_rows - 1.0

接受行数限制的 TABLESAMPLE 方法

Extension Website Attributes
Package tsm_system_rows
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

tcn - 1.0

用触发器通知变更

Extension Website Attributes
Package tcn
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

uuid-ossp - 1.1

生成通用唯一标识符(UUIDs)

Extension Website Attributes
Package uuid-ossp
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

btree_gist - 1.7

用GiST索引常见数据类型

Extension Website Attributes
Package btree_gist
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

btree_gin - 1.3

用GIN索引常见数据类型

Extension Website Attributes
Package btree_gin
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

intarray - 1.5

1维整数数组的额外函数、运算符和索引支持

Extension Website Attributes
Package intarray
RPM postgresql$v-contrib DDL
DEB postgresql-$v
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

intagg - 1.1

整数聚合器和枚举器(过时)

Extension Website Attributes
Package intagg
RPM postgresql$v-contrib DDL
DEB postgresql-$v
Language C
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

dict_int - 1.0

用于整数的文本搜索字典模板

Extension Website Attributes
Package dict_int
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24

unaccent - 1.1

删除重音的文本搜索字典

Extension Website Attributes
Package unaccent
RPM postgresql$v-contrib DDL
DEB postgresql-$v LIB
Language C TRUST
License PostgreSQL
OS/Archx86_64aarch64
el8
el9
el10
d12
d13
u22
u24