aggs_for_vecs

Aggregate functions for array inputs

Overview

Package	Version	Category	License	Language
`aggs_for_vecs`	`1.4.1`	FUNC	MIT	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
4740	`aggs_for_vecs`	No	Yes	No	Yes	No	Yes	-

Related	`intarray` `arraymath` `floatvec` `aggs_for_arrays`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PIGSTY	`1.4.1`	1817161514	`aggs_for_vecs`	-
RPM	PIGSTY	`1.4.1`	1817161514	`aggs_for_vecs_$v`	-
DEB	PIGSTY	`1.4.1`	1817161514	`postgresql-$v-aggs-for-vecs`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.4.1 el8.x86_64.pg18 : aggs_for_vecs_18 aggs_for_vecs_18-1.4.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.4.1 · 43.9KiB	PIGSTY 1.4.1 el8.x86_64.pg17 : aggs_for_vecs_17 aggs_for_vecs_17-1.4.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.4.1 · 43.9KiB	PIGSTY 1.4.1 el8.x86_64.pg16 : aggs_for_vecs_16 aggs_for_vecs_16-1.4.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.4.1 · 43.8KiB	PIGSTY 1.4.1 el8.x86_64.pg15 : aggs_for_vecs_15 aggs_for_vecs_15-1.4.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.4.1 · 44.0KiB	PIGSTY 1.4.1 el8.x86_64.pg14 : aggs_for_vecs_14 aggs_for_vecs_14-1.4.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.4.1 · 44.0KiB
el8.aarch64	PIGSTY 1.4.1 el8.aarch64.pg18 : aggs_for_vecs_18 aggs_for_vecs_18-1.4.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.4.1 · 43.9KiB	PIGSTY 1.4.1 el8.aarch64.pg17 : aggs_for_vecs_17 aggs_for_vecs_17-1.4.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.4.1 · 43.9KiB	PIGSTY 1.4.1 el8.aarch64.pg16 : aggs_for_vecs_16 aggs_for_vecs_16-1.4.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.4.1 · 43.9KiB	PIGSTY 1.4.1 el8.aarch64.pg15 : aggs_for_vecs_15 aggs_for_vecs_15-1.4.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.4.1 · 43.7KiB	PIGSTY 1.4.1 el8.aarch64.pg14 : aggs_for_vecs_14 aggs_for_vecs_14-1.4.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.4.1 · 43.7KiB
el9.x86_64	PIGSTY 1.4.1 el9.x86_64.pg18 : aggs_for_vecs_18 aggs_for_vecs_18-1.4.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.4.1 · 42.4KiB	PIGSTY 1.4.1 el9.x86_64.pg17 : aggs_for_vecs_17 aggs_for_vecs_17-1.4.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.4.1 · 42.6KiB	PIGSTY 1.4.1 el9.x86_64.pg16 : aggs_for_vecs_16 aggs_for_vecs_16-1.4.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.4.1 · 42.6KiB	PIGSTY 1.4.1 el9.x86_64.pg15 : aggs_for_vecs_15 aggs_for_vecs_15-1.4.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.4.1 · 42.9KiB	PIGSTY 1.4.1 el9.x86_64.pg14 : aggs_for_vecs_14 aggs_for_vecs_14-1.4.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.4.1 · 42.8KiB
el9.aarch64	PIGSTY 1.4.1 el9.aarch64.pg18 : aggs_for_vecs_18 aggs_for_vecs_18-1.4.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.4.1 · 43.4KiB	PIGSTY 1.4.1 el9.aarch64.pg17 : aggs_for_vecs_17 aggs_for_vecs_17-1.4.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.4.1 · 43.5KiB	PIGSTY 1.4.1 el9.aarch64.pg16 : aggs_for_vecs_16 aggs_for_vecs_16-1.4.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.4.1 · 43.5KiB	PIGSTY 1.4.1 el9.aarch64.pg15 : aggs_for_vecs_15 aggs_for_vecs_15-1.4.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.4.1 · 43.5KiB	PIGSTY 1.4.1 el9.aarch64.pg14 : aggs_for_vecs_14 aggs_for_vecs_14-1.4.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.4.1 · 43.5KiB
el10.x86_64	PIGSTY 1.4.1 el10.x86_64.pg18 : aggs_for_vecs_18 aggs_for_vecs_18-1.4.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.4.1 · 42.4KiB	PIGSTY 1.4.1 el10.x86_64.pg17 : aggs_for_vecs_17 aggs_for_vecs_17-1.4.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.4.1 · 42.3KiB	PIGSTY 1.4.1 el10.x86_64.pg16 : aggs_for_vecs_16 aggs_for_vecs_16-1.4.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.4.1 · 42.3KiB	PIGSTY 1.4.1 el10.x86_64.pg15 : aggs_for_vecs_15 aggs_for_vecs_15-1.4.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.4.1 · 42.6KiB	PIGSTY 1.4.1 el10.x86_64.pg14 : aggs_for_vecs_14 aggs_for_vecs_14-1.4.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.4.1 · 42.6KiB
el10.aarch64	PIGSTY 1.4.1 el10.aarch64.pg18 : aggs_for_vecs_18 aggs_for_vecs_18-1.4.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.4.1 · 43.7KiB	PIGSTY 1.4.1 el10.aarch64.pg17 : aggs_for_vecs_17 aggs_for_vecs_17-1.4.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.4.1 · 43.8KiB	PIGSTY 1.4.1 el10.aarch64.pg16 : aggs_for_vecs_16 aggs_for_vecs_16-1.4.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.4.1 · 43.8KiB	PIGSTY 1.4.1 el10.aarch64.pg15 : aggs_for_vecs_15 aggs_for_vecs_15-1.4.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.4.1 · 43.8KiB	PIGSTY 1.4.1 el10.aarch64.pg14 : aggs_for_vecs_14 aggs_for_vecs_14-1.4.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.4.1 · 43.8KiB
d12.x86_64	PIGSTY 1.4.1 d12.x86_64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.1 · 82.1KiB	PIGSTY 1.4.1 d12.x86_64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.1 · 82.3KiB	PIGSTY 1.4.1 d12.x86_64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.1 · 82.3KiB	PIGSTY 1.4.1 d12.x86_64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.1 · 82.5KiB	PIGSTY 1.4.1 d12.x86_64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.4.1 · 82.3KiB
d12.aarch64	PIGSTY 1.4.1 d12.aarch64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.1 · 82.2KiB	PIGSTY 1.4.1 d12.aarch64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.1 · 82.2KiB	PIGSTY 1.4.1 d12.aarch64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.1 · 82.2KiB	PIGSTY 1.4.1 d12.aarch64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.1 · 82.2KiB	PIGSTY 1.4.1 d12.aarch64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.4.1 · 82.5KiB
d13.x86_64	PIGSTY 1.4.1 d13.x86_64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.4.1 · 81.9KiB	PIGSTY 1.4.1 d13.x86_64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.4.1 · 81.7KiB	PIGSTY 1.4.1 d13.x86_64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.4.1 · 81.7KiB	PIGSTY 1.4.1 d13.x86_64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.4.1 · 82.1KiB	PIGSTY 1.4.1 d13.x86_64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.4.1 · 81.9KiB
d13.aarch64	PIGSTY 1.4.1 d13.aarch64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.4.1 · 82.2KiB	PIGSTY 1.4.1 d13.aarch64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.4.1 · 82.3KiB	PIGSTY 1.4.1 d13.aarch64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.4.1 · 82.2KiB	PIGSTY 1.4.1 d13.aarch64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.4.1 · 82.3KiB	PIGSTY 1.4.1 d13.aarch64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.4.1 · 82.1KiB
u22.x86_64	PIGSTY 1.4.1 u22.x86_64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.4.1 · 88.6KiB	PIGSTY 1.4.1 u22.x86_64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.4.1 · 93.0KiB	PIGSTY 1.4.1 u22.x86_64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.4.1 · 93.0KiB	PIGSTY 1.4.1 u22.x86_64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.4.1 · 93.2KiB	PIGSTY 1.4.1 u22.x86_64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.4.1 · 93.0KiB
u22.aarch64	PIGSTY 1.4.1 u22.aarch64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.4.1 · 89.2KiB	PIGSTY 1.4.1 u22.aarch64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.4.1 · 93.7KiB	PIGSTY 1.4.1 u22.aarch64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.4.1 · 93.7KiB	PIGSTY 1.4.1 u22.aarch64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.4.1 · 93.5KiB	PIGSTY 1.4.1 u22.aarch64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.4.1 · 93.5KiB
u24.x86_64	PIGSTY 1.4.1 u24.x86_64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.4.1 · 84.7KiB	PIGSTY 1.4.1 u24.x86_64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.4.1 · 84.7KiB	PIGSTY 1.4.1 u24.x86_64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.4.1 · 85.0KiB	PIGSTY 1.4.1 u24.x86_64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.4.1 · 85.3KiB	PIGSTY 1.4.1 u24.x86_64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.4.1 · 85.2KiB
u24.aarch64	PIGSTY 1.4.1 u24.aarch64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.4.1 · 86.4KiB	PIGSTY 1.4.1 u24.aarch64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.4.1 · 86.4KiB	PIGSTY 1.4.1 u24.aarch64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.4.1 · 86.4KiB	PIGSTY 1.4.1 u24.aarch64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.4.1 · 86.5KiB	PIGSTY 1.4.1 u24.aarch64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.4.1 · 86.3KiB
u26.x86_64	PIGSTY 1.4.1 u26.x86_64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.4.1 · 85.8KiB	PIGSTY 1.4.1 u26.x86_64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.4.1 · 85.8KiB	PIGSTY 1.4.1 u26.x86_64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.4.1 · 85.7KiB	PIGSTY 1.4.1 u26.x86_64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.4.1 · 86.2KiB	PIGSTY 1.4.1 u26.x86_64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.4.1 · 86.0KiB
u26.aarch64	PIGSTY 1.4.1 u26.aarch64.pg18 : postgresql-18-aggs-for-vecs postgresql-18-aggs-for-vecs_1.4.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.4.1 · 87.9KiB	PIGSTY 1.4.1 u26.aarch64.pg17 : postgresql-17-aggs-for-vecs postgresql-17-aggs-for-vecs_1.4.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.4.1 · 88.1KiB	PIGSTY 1.4.1 u26.aarch64.pg16 : postgresql-16-aggs-for-vecs postgresql-16-aggs-for-vecs_1.4.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.4.1 · 88.1KiB	PIGSTY 1.4.1 u26.aarch64.pg15 : postgresql-15-aggs-for-vecs postgresql-15-aggs-for-vecs_1.4.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.4.1 · 88.1KiB	PIGSTY 1.4.1 u26.aarch64.pg14 : postgresql-14-aggs-for-vecs postgresql-14-aggs-for-vecs_1.4.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.4.1 · 87.9KiB

Build

You can build the RPM / DEB packages for aggs_for_vecs using pig build:

pig build pkg aggs_for_vecs         # build RPM / DEB packages

Install

You can install aggs_for_vecs directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

Install

pig install aggs_for_vecs;          # Install for current active PG version

pig

pig ext install -y aggs_for_vecs -v 18  # PG 18
pig ext install -y aggs_for_vecs -v 17  # PG 17
pig ext install -y aggs_for_vecs -v 16  # PG 16
pig ext install -y aggs_for_vecs -v 15  # PG 15
pig ext install -y aggs_for_vecs -v 14  # PG 14

dnf

dnf install -y aggs_for_vecs_18       # PG 18
dnf install -y aggs_for_vecs_17       # PG 17
dnf install -y aggs_for_vecs_16       # PG 16
dnf install -y aggs_for_vecs_15       # PG 15
dnf install -y aggs_for_vecs_14       # PG 14

apt

apt install -y postgresql-18-aggs-for-vecs   # PG 18
apt install -y postgresql-17-aggs-for-vecs   # PG 17
apt install -y postgresql-16-aggs-for-vecs   # PG 16
apt install -y postgresql-15-aggs-for-vecs   # PG 15
apt install -y postgresql-14-aggs-for-vecs   # PG 14

Create Extension:

CREATE EXTENSION aggs_for_vecs;

Usage

aggs_for_vecs: aggregate functions for arrays (vector/row-based)

Provides aggregate functions that operate on arrays as vectors, computing position-wise statistics across multiple rows. Supports SMALLINT, INTEGER, BIGINT, REAL, and DOUBLE PRECISION.

CREATE EXTENSION aggs_for_vecs;

Aggregate Functions

Function	Description
`vec_to_count(anyarray)`	Count of non-nulls in each position
`vec_to_sum(anyarray)`	Sum in each position
`vec_to_min(anyarray)`	Minimum in each position
`vec_to_max(anyarray)`	Maximum in each position
`vec_to_mean(anyarray)`	Average in each position (returns `FLOAT[]`)
`vec_to_weighted_mean(values, weights)`	Weighted average in each position
`vec_to_var_samp(anyarray)`	Sample variance in each position
`vec_to_first(anyarray)`	First non-null in each position (use with ORDER BY)
`vec_to_last(anyarray)`	Last non-null in each position (use with ORDER BY)
`hist_2d(x, y, ...)`	2-D histogram
`hist_md(vals, indexes, ...)`	N-dimensional histogram

Non-Aggregate Functions

Function	Description
`vec_add(l, r)`	Element-wise addition
`vec_sub(l, r)`	Element-wise subtraction
`vec_mul(l, r)`	Element-wise multiplication
`vec_div(l, r)`	Element-wise division
`vec_elements(array, indexes)`	Select elements at given indexes
`pad_vec(array, length)`	Extend array to given length with NULLs
`vec_coalesce(array, default)`	Replace NULLs with default
`vec_trim_scale(numeric[])`	Trim trailing zeros from NUMERIC elements
`vec_without_outliers(vals, mins, maxs)`	Replace outliers with NULL

Examples

-- Position-wise minimum across rows
SELECT vec_to_min(vals) FROM (VALUES
  (ARRAY[1,2,3,4]),
  (ARRAY[5,0,-5,0]),
  (ARRAY[3,6,0,9])
) AS t(vals);
-- {1,0,-5,0}

-- Position-wise average
SELECT vec_to_mean(vals) FROM my_table;

aggs_for_vecs

Overview

Version

Build

Install

Usage

Aggregate Functions

Non-Aggregate Functions

Examples

Was this page helpful?