floatvec

Math for vectors (arrays) of numbers

FUNC

PIGSTY

floatvec : Math for vectors (arrays) of numbers

Overview

ID	Extension	Package	Version	Category	License	Language
4730	floatvec	floatvec	`1.1.1`	FUNC	MIT	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d-r	No	Yes	No	Yes	yes	no

Relationships
See Also	intarray arraymath aggs_for_vecs aggs_for_arrays

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PIGSTY	`1.1.1`	18 17 16 15 14	`floatvec`	-
RPM	PIGSTY	`1.1.1`	18 17 16 15 14	`floatvec_$v`	-
DEB	PIGSTY	`1.1.1`	18 17 16 15 14	`postgresql-$v-floatvec`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
el8.aarch64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
el9.x86_64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
el9.aarch64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
el10.x86_64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
el10.aarch64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
d12.x86_64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
d12.aarch64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
d13.x86_64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
d13.aarch64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
u22.x86_64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
u22.aarch64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
u24.x86_64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
u24.aarch64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
u26.x86_64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1
u26.aarch64	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1	PIGSTY 1.1.1

Package	Version	OS	ORG	SIZE	File URL
`floatvec_18`	`1.1.1`	el8.x86_64	pigsty	18.1 KiB	floatvec_18-1.1.1-1PIGSTY.el8.x86_64.rpm
`floatvec_18`	`1.1.1`	el8.aarch64	pigsty	19.3 KiB	floatvec_18-1.1.1-1PIGSTY.el8.aarch64.rpm
`floatvec_18`	`1.1.1`	el9.x86_64	pigsty	18.0 KiB	floatvec_18-1.1.1-1PIGSTY.el9.x86_64.rpm
`floatvec_18`	`1.1.1`	el9.aarch64	pigsty	19.2 KiB	floatvec_18-1.1.1-1PIGSTY.el9.aarch64.rpm
`floatvec_18`	`1.1.1`	el10.x86_64	pigsty	17.8 KiB	floatvec_18-1.1.1-1PIGSTY.el10.x86_64.rpm
`floatvec_18`	`1.1.1`	el10.aarch64	pigsty	19.5 KiB	floatvec_18-1.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-18-floatvec`	`1.1.1`	d12.x86_64	pigsty	24.0 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~bookworm_amd64.deb
`postgresql-18-floatvec`	`1.1.1`	d12.aarch64	pigsty	25.3 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~bookworm_arm64.deb
`postgresql-18-floatvec`	`1.1.1`	d13.x86_64	pigsty	24.0 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-18-floatvec`	`1.1.1`	d13.aarch64	pigsty	25.3 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-18-floatvec`	`1.1.1`	u22.x86_64	pigsty	25.2 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~jammy_amd64.deb
`postgresql-18-floatvec`	`1.1.1`	u22.aarch64	pigsty	26.7 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~jammy_arm64.deb
`postgresql-18-floatvec`	`1.1.1`	u24.x86_64	pigsty	25.2 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~noble_amd64.deb
`postgresql-18-floatvec`	`1.1.1`	u24.aarch64	pigsty	26.7 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~noble_arm64.deb
`postgresql-18-floatvec`	`1.1.1`	u26.x86_64	pigsty	25.6 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~resolute_amd64.deb
`postgresql-18-floatvec`	`1.1.1`	u26.aarch64	pigsty	27.0 KiB	postgresql-18-floatvec_1.1.1-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`floatvec_17`	`1.1.1`	el8.x86_64	pigsty	18.1 KiB	floatvec_17-1.1.1-1PIGSTY.el8.x86_64.rpm
`floatvec_17`	`1.1.1`	el8.aarch64	pigsty	19.3 KiB	floatvec_17-1.1.1-1PIGSTY.el8.aarch64.rpm
`floatvec_17`	`1.1.1`	el9.x86_64	pigsty	18.0 KiB	floatvec_17-1.1.1-1PIGSTY.el9.x86_64.rpm
`floatvec_17`	`1.1.1`	el9.aarch64	pigsty	19.2 KiB	floatvec_17-1.1.1-1PIGSTY.el9.aarch64.rpm
`floatvec_17`	`1.1.1`	el10.x86_64	pigsty	17.8 KiB	floatvec_17-1.1.1-1PIGSTY.el10.x86_64.rpm
`floatvec_17`	`1.1.1`	el10.aarch64	pigsty	19.5 KiB	floatvec_17-1.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-17-floatvec`	`1.1.1`	d12.x86_64	pigsty	24.0 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~bookworm_amd64.deb
`postgresql-17-floatvec`	`1.1.1`	d12.aarch64	pigsty	25.3 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~bookworm_arm64.deb
`postgresql-17-floatvec`	`1.1.1`	d13.x86_64	pigsty	24.0 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-17-floatvec`	`1.1.1`	d13.aarch64	pigsty	25.2 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-17-floatvec`	`1.1.1`	u22.x86_64	pigsty	25.8 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~jammy_amd64.deb
`postgresql-17-floatvec`	`1.1.1`	u22.aarch64	pigsty	27.3 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~jammy_arm64.deb
`postgresql-17-floatvec`	`1.1.1`	u24.x86_64	pigsty	25.2 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~noble_amd64.deb
`postgresql-17-floatvec`	`1.1.1`	u24.aarch64	pigsty	26.6 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~noble_arm64.deb
`postgresql-17-floatvec`	`1.1.1`	u26.x86_64	pigsty	25.5 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~resolute_amd64.deb
`postgresql-17-floatvec`	`1.1.1`	u26.aarch64	pigsty	26.9 KiB	postgresql-17-floatvec_1.1.1-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`floatvec_16`	`1.1.1`	el8.x86_64	pigsty	18.1 KiB	floatvec_16-1.1.1-1PIGSTY.el8.x86_64.rpm
`floatvec_16`	`1.1.1`	el8.aarch64	pigsty	19.3 KiB	floatvec_16-1.1.1-1PIGSTY.el8.aarch64.rpm
`floatvec_16`	`1.1.1`	el9.x86_64	pigsty	18.0 KiB	floatvec_16-1.1.1-1PIGSTY.el9.x86_64.rpm
`floatvec_16`	`1.1.1`	el9.aarch64	pigsty	19.2 KiB	floatvec_16-1.1.1-1PIGSTY.el9.aarch64.rpm
`floatvec_16`	`1.1.1`	el10.x86_64	pigsty	17.9 KiB	floatvec_16-1.1.1-1PIGSTY.el10.x86_64.rpm
`floatvec_16`	`1.1.1`	el10.aarch64	pigsty	19.5 KiB	floatvec_16-1.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-16-floatvec`	`1.1.1`	d12.x86_64	pigsty	24.0 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~bookworm_amd64.deb
`postgresql-16-floatvec`	`1.1.1`	d12.aarch64	pigsty	25.3 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~bookworm_arm64.deb
`postgresql-16-floatvec`	`1.1.1`	d13.x86_64	pigsty	24.0 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-16-floatvec`	`1.1.1`	d13.aarch64	pigsty	25.3 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-16-floatvec`	`1.1.1`	u22.x86_64	pigsty	25.8 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~jammy_amd64.deb
`postgresql-16-floatvec`	`1.1.1`	u22.aarch64	pigsty	27.4 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~jammy_arm64.deb
`postgresql-16-floatvec`	`1.1.1`	u24.x86_64	pigsty	25.2 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~noble_amd64.deb
`postgresql-16-floatvec`	`1.1.1`	u24.aarch64	pigsty	26.6 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~noble_arm64.deb
`postgresql-16-floatvec`	`1.1.1`	u26.x86_64	pigsty	25.5 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~resolute_amd64.deb
`postgresql-16-floatvec`	`1.1.1`	u26.aarch64	pigsty	27.0 KiB	postgresql-16-floatvec_1.1.1-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`floatvec_15`	`1.1.1`	el8.x86_64	pigsty	18.1 KiB	floatvec_15-1.1.1-1PIGSTY.el8.x86_64.rpm
`floatvec_15`	`1.1.1`	el8.aarch64	pigsty	19.0 KiB	floatvec_15-1.1.1-1PIGSTY.el8.aarch64.rpm
`floatvec_15`	`1.1.1`	el9.x86_64	pigsty	18.0 KiB	floatvec_15-1.1.1-1PIGSTY.el9.x86_64.rpm
`floatvec_15`	`1.1.1`	el9.aarch64	pigsty	18.8 KiB	floatvec_15-1.1.1-1PIGSTY.el9.aarch64.rpm
`floatvec_15`	`1.1.1`	el10.x86_64	pigsty	17.9 KiB	floatvec_15-1.1.1-1PIGSTY.el10.x86_64.rpm
`floatvec_15`	`1.1.1`	el10.aarch64	pigsty	19.2 KiB	floatvec_15-1.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-15-floatvec`	`1.1.1`	d12.x86_64	pigsty	23.6 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~bookworm_amd64.deb
`postgresql-15-floatvec`	`1.1.1`	d12.aarch64	pigsty	24.4 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~bookworm_arm64.deb
`postgresql-15-floatvec`	`1.1.1`	d13.x86_64	pigsty	23.6 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-15-floatvec`	`1.1.1`	d13.aarch64	pigsty	24.5 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-15-floatvec`	`1.1.1`	u22.x86_64	pigsty	25.7 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~jammy_amd64.deb
`postgresql-15-floatvec`	`1.1.1`	u22.aarch64	pigsty	26.8 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~jammy_arm64.deb
`postgresql-15-floatvec`	`1.1.1`	u24.x86_64	pigsty	24.7 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~noble_amd64.deb
`postgresql-15-floatvec`	`1.1.1`	u24.aarch64	pigsty	25.8 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~noble_arm64.deb
`postgresql-15-floatvec`	`1.1.1`	u26.x86_64	pigsty	25.2 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~resolute_amd64.deb
`postgresql-15-floatvec`	`1.1.1`	u26.aarch64	pigsty	26.5 KiB	postgresql-15-floatvec_1.1.1-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`floatvec_14`	`1.1.1`	el8.x86_64	pigsty	18.1 KiB	floatvec_14-1.1.1-1PIGSTY.el8.x86_64.rpm
`floatvec_14`	`1.1.1`	el8.aarch64	pigsty	19.0 KiB	floatvec_14-1.1.1-1PIGSTY.el8.aarch64.rpm
`floatvec_14`	`1.1.1`	el9.x86_64	pigsty	17.9 KiB	floatvec_14-1.1.1-1PIGSTY.el9.x86_64.rpm
`floatvec_14`	`1.1.1`	el9.aarch64	pigsty	18.8 KiB	floatvec_14-1.1.1-1PIGSTY.el9.aarch64.rpm
`floatvec_14`	`1.1.1`	el10.x86_64	pigsty	17.9 KiB	floatvec_14-1.1.1-1PIGSTY.el10.x86_64.rpm
`floatvec_14`	`1.1.1`	el10.aarch64	pigsty	19.2 KiB	floatvec_14-1.1.1-1PIGSTY.el10.aarch64.rpm
`postgresql-14-floatvec`	`1.1.1`	d12.x86_64	pigsty	23.6 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~bookworm_amd64.deb
`postgresql-14-floatvec`	`1.1.1`	d12.aarch64	pigsty	24.4 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~bookworm_arm64.deb
`postgresql-14-floatvec`	`1.1.1`	d13.x86_64	pigsty	23.6 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~trixie_amd64.deb
`postgresql-14-floatvec`	`1.1.1`	d13.aarch64	pigsty	24.5 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~trixie_arm64.deb
`postgresql-14-floatvec`	`1.1.1`	u22.x86_64	pigsty	25.7 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~jammy_amd64.deb
`postgresql-14-floatvec`	`1.1.1`	u22.aarch64	pigsty	26.7 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~jammy_arm64.deb
`postgresql-14-floatvec`	`1.1.1`	u24.x86_64	pigsty	24.7 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~noble_amd64.deb
`postgresql-14-floatvec`	`1.1.1`	u24.aarch64	pigsty	25.7 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~noble_arm64.deb
`postgresql-14-floatvec`	`1.1.1`	u26.x86_64	pigsty	25.2 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~resolute_amd64.deb
`postgresql-14-floatvec`	`1.1.1`	u26.aarch64	pigsty	26.4 KiB	postgresql-14-floatvec_1.1.1-1PIGSTY~resolute_arm64.deb

Source

Repository

github.com/pjungwir/floatvec

Source Tarball

floatvec-1.1.1.tar.gz

pig build pkg floatvec;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

pig install floatvec;		# install via package name, for the active PG version

pig install floatvec -v 18;   # install for PG 18
pig install floatvec -v 17;   # install for PG 17
pig install floatvec -v 16;   # install for PG 16
pig install floatvec -v 15;   # install for PG 15
pig install floatvec -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION floatvec;

Usage

floatvec: element-by-element arithmetic on PostgreSQL arrays

Provides basic arithmetic functions for operating on arrays treated as vectors. Supports SMALLINT, INTEGER, BIGINT, REAL, and DOUBLE PRECISION.

CREATE EXTENSION floatvec;

Functions

Each function accepts two arrays of the same length, or an array and a scalar, or a scalar and an array. Both arguments must be of the same type.

Function	Description
`vec_add(a, b)`	Element-by-element addition
`vec_sub(a, b)`	Element-by-element subtraction
`vec_mul(a, b)`	Element-by-element multiplication
`vec_div(a, b)`	Element-by-element division
`vec_pow(a, b)`	Element-by-element exponentiation

Examples

-- Array + Array
SELECT vec_add(ARRAY[1,2,3], ARRAY[10,20,30]);  -- {11,22,33}

-- Array * Scalar
SELECT vec_mul(ARRAY[1.0, 2.0, 3.0], 2.0);     -- {2.0, 4.0, 6.0}

-- Scalar - Array
SELECT vec_sub(10, ARRAY[1,2,3]);               -- {9,8,7}