Category: FUNC

FUNC: Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions…

Module:

PGSQL

Tags:

FUNC

FUNC category has 41 available extensions:

Name (Detail)	Package (Repo)	Repo	Version	Category	License	Description
pg_idkit	`pg_idkit`	PIGSTY	0.2.4	`FUNC`	Apache-2.0	multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pg_uuidv7	`pg_uuidv7`	MIXED	1.6	`FUNC`	MPLv2	pg_uuidv7: create UUIDv7 values in postgres
permuteseq	`permuteseq`	PIGSTY	1.2	`FUNC`	PostgreSQL	Pseudo-randomly permute sequences with a format-preserving encryption on elements
pg_hashids	`pg_hashids`	PIGSTY	1.3	`FUNC`	MIT	Short unique id generator for PostgreSQL, using hashids
sequential_uuids	`sequential_uuids`	MIXED	1.0.3	`FUNC`	MIT	generator of sequential UUIDs
topn	`topn`	PGDG	2.7.0	`FUNC`	AGPLv3	type for top-n JSONB
quantile	`quantile`	PIGSTY	1.1.8	`FUNC`	BSD 2	Quantile aggregation function
lower_quantile	`lower_quantile`	PIGSTY	1.0.3	`FUNC`	BSD 2	Lower quantile aggregate function
count_distinct	`count_distinct`	MIXED	3.0.2	`FUNC`	BSD 2	An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
omnisketch	`omnisketch`	PIGSTY	1.0.1	`FUNC`	PostgreSQL	data structure for on-line agg of data into approximate sketch
ddsketch	`ddsketch`	PIGSTY	1.0.1	`FUNC`	PostgreSQL	Provides ddsketch aggregate function
vasco	`vasco`	PIGSTY	0.1.0	`FUNC`	GPLv3	discover hidden correlations in your data with MIC
xicor	`pgxicor`	PIGSTY	0.1.0	`FUNC`	GPLv3	XI Correlation Coefficient in Postgres
tdigest	`tdigest`	PGDG	1.4.3	`FUNC`	Apache-2.0	Provides tdigest aggregate function.
first_last_agg	`first_last_agg`	MIXED	0.1.4	`FUNC`	PostgreSQL	first() and last() aggregate functions
extra_window_functions	`extra_window_functions`	PGDG	1.0	`FUNC`	PostgreSQL	Extra Window Functions for PostgreSQL
floatvec	`floatvec`	PIGSTY	1.1.1	`FUNC`	MIT	Math for vectors (arrays) of numbers
aggs_for_vecs	`aggs_for_vecs`	PIGSTY	1.3.2	`FUNC`	MIT	Aggregate functions for array inputs
aggs_for_arrays	`aggs_for_arrays`	PIGSTY	1.3.3	`FUNC`	MIT	Various functions for computing statistics on arrays of numbers
arraymath	`pg_arraymath`	PIGSTY	1.1	`FUNC`	MIT	Array math and operators that work element by element on the contents of arrays
pg_math	`pg_math`	PIGSTY	1.0	`FUNC`	GPLv3	GSL statistical functions for postgresql
random	`pg_random`	PIGSTY	2.0.0-dev	`FUNC`	PostgreSQL	random data generator
base36	`pg_base36`	PIGSTY	1.0.0	`FUNC`	MIT	Integer Base36 types
base62	`pg_base62`	PIGSTY	0.0.1	`FUNC`	MIT	Base62 extension for PostgreSQL
pg_base58	`pg_base58`	PIGSTY	0.0.1	`FUNC`	MIT	Base58 Encoder/Decoder Extension for PostgreSQL
financial	`pg_financial`	PIGSTY	1.0.1	`FUNC`	PostgreSQL	Financial aggregate functions
refint	`refint`	CONTRIB	1.0	`FUNC`	PostgreSQL	functions for implementing referential integrity (obsolete)
autoinc	`autoinc`	CONTRIB	1.0	`FUNC`	PostgreSQL	functions for autoincrementing fields
insert_username	`insert_username`	CONTRIB	1.0	`FUNC`	PostgreSQL	functions for tracking who changed a table
moddatetime	`moddatetime`	CONTRIB	1.0	`FUNC`	PostgreSQL	functions for tracking last modification time
tsm_system_time	`tsm_system_time`	CONTRIB	1.0	`FUNC`	PostgreSQL	TABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsyn	`dict_xsyn`	CONTRIB	1.0	`FUNC`	PostgreSQL	text search dictionary template for extended synonym processing
tsm_system_rows	`tsm_system_rows`	CONTRIB	1.0	`FUNC`	PostgreSQL	TABLESAMPLE method which accepts number of rows as a limit
tcn	`tcn`	CONTRIB	1.0	`FUNC`	PostgreSQL	Triggered change notifications
uuid-ossp	`uuid-ossp`	CONTRIB	1.1	`FUNC`	PostgreSQL	generate universally unique identifiers (UUIDs)
btree_gist	`btree_gist`	CONTRIB	1.7	`FUNC`	PostgreSQL	support for indexing common datatypes in GiST
btree_gin	`btree_gin`	CONTRIB	1.3	`FUNC`	PostgreSQL	support for indexing common datatypes in GIN
intarray	`intarray`	CONTRIB	1.5	`FUNC`	PostgreSQL	functions, operators, and index support for 1-D arrays of integers
intagg	`intagg`	CONTRIB	1.1	`FUNC`	PostgreSQL	integer aggregator and enumerator (obsolete)
dict_int	`dict_int`	CONTRIB	1.0	`FUNC`	PostgreSQL	text search dictionary template for integers
unaccent	`unaccent`	CONTRIB	1.1	`FUNC`	PostgreSQL	text search dictionary that removes accents