extra_window_functions

extra_window_functions : Extra Window Functions for PostgreSQL

Overview

ID	Extension	Package	Version	Category	License	Language
4720	extra_window_functions	extra_window_functions	`1.0`	FUNC	PostgreSQL	C

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

Relationships
See Also	pg_idkit pgx_ulid pg_uuidv7 permuteseq pg_hashids sequential_uuids topn quantile

no pg14,13,12 on el8/9

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PGDG	`1.0`	18 17 16 15 14 13	`extra_window_functions`	-
RPM	PGDG	`1.0`	18 17 16 15 14 13	`extra_window_functions_$v*`	-
DEB	PGDG	`1.0`	18 17 16 15 14 13	`postgresql-$v-extra-window-functions`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	MISS
el8.aarch64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
el9.x86_64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	MISS	MISS
el9.aarch64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
el10.x86_64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
el10.aarch64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
d12.x86_64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
d12.aarch64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
d13.x86_64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
d13.aarch64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
u22.x86_64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
u22.aarch64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
u24.x86_64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0
u24.aarch64	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0	PGDG 1.0

Package	Version	OS	ORG	SIZE	File URL
`extra_window_functions_18`	`1.0`	el8.x86_64	pgdg	24.5 KiB	extra_window_functions_18-1.0-6PGDG.rhel8.x86_64.rpm
`extra_window_functions_18`	`1.0`	el8.aarch64	pgdg	24.3 KiB	extra_window_functions_18-1.0-6PGDG.rhel8.aarch64.rpm
`extra_window_functions_18`	`1.0`	el9.x86_64	pgdg	24.8 KiB	extra_window_functions_18-1.0-6PGDG.rhel9.x86_64.rpm
`extra_window_functions_18`	`1.0`	el9.aarch64	pgdg	24.4 KiB	extra_window_functions_18-1.0-6PGDG.rhel9.aarch64.rpm
`extra_window_functions_18`	`1.0`	el10.x86_64	pgdg	25.2 KiB	extra_window_functions_18-1.0-6PGDG.rhel10.x86_64.rpm
`extra_window_functions_18`	`1.0`	el10.aarch64	pgdg	25.1 KiB	extra_window_functions_18-1.0-6PGDG.rhel10.aarch64.rpm
`postgresql-18-extra-window-functions`	`1.0`	d12.x86_64	pgdg	15.8 KiB	postgresql-18-extra-window-functions_1.0-7.pgdg12+1_amd64.deb
`postgresql-18-extra-window-functions`	`1.0`	d12.aarch64	pgdg	15.9 KiB	postgresql-18-extra-window-functions_1.0-7.pgdg12+1_arm64.deb
`postgresql-18-extra-window-functions`	`1.0`	d13.x86_64	pgdg	15.8 KiB	postgresql-18-extra-window-functions_1.0-7.pgdg13+1_amd64.deb
`postgresql-18-extra-window-functions`	`1.0`	d13.aarch64	pgdg	15.9 KiB	postgresql-18-extra-window-functions_1.0-7.pgdg13+1_arm64.deb
`postgresql-18-extra-window-functions`	`1.0`	u22.x86_64	pgdg	15.5 KiB	postgresql-18-extra-window-functions_1.0-7.pgdg22.04+1_amd64.deb
`postgresql-18-extra-window-functions`	`1.0`	u22.aarch64	pgdg	15.6 KiB	postgresql-18-extra-window-functions_1.0-7.pgdg22.04+1_arm64.deb
`postgresql-18-extra-window-functions`	`1.0`	u24.x86_64	pgdg	15.8 KiB	postgresql-18-extra-window-functions_1.0-7.pgdg24.04+1_amd64.deb
`postgresql-18-extra-window-functions`	`1.0`	u24.aarch64	pgdg	15.9 KiB	postgresql-18-extra-window-functions_1.0-7.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`extra_window_functions_17`	`1.0`	el8.x86_64	pgdg	24.3 KiB	extra_window_functions_17-1.0-5PGDG.rhel8.x86_64.rpm
`extra_window_functions_17`	`1.0`	el8.aarch64	pgdg	24.2 KiB	extra_window_functions_17-1.0-5PGDG.rhel8.aarch64.rpm
`extra_window_functions_17`	`1.0`	el9.x86_64	pgdg	24.7 KiB	extra_window_functions_17-1.0-5PGDG.rhel9.x86_64.rpm
`extra_window_functions_17`	`1.0`	el9.aarch64	pgdg	24.5 KiB	extra_window_functions_17-1.0-5PGDG.rhel9.aarch64.rpm
`extra_window_functions_17`	`1.0`	el10.x86_64	pgdg	25.1 KiB	extra_window_functions_17-1.0-6PGDG.rhel10.x86_64.rpm
`extra_window_functions_17`	`1.0`	el10.aarch64	pgdg	25.1 KiB	extra_window_functions_17-1.0-6PGDG.rhel10.aarch64.rpm
`postgresql-17-extra-window-functions`	`1.0`	d12.x86_64	pgdg	15.8 KiB	postgresql-17-extra-window-functions_1.0-7.pgdg12+1_amd64.deb
`postgresql-17-extra-window-functions`	`1.0`	d12.aarch64	pgdg	15.8 KiB	postgresql-17-extra-window-functions_1.0-7.pgdg12+1_arm64.deb
`postgresql-17-extra-window-functions`	`1.0`	d13.x86_64	pgdg	15.8 KiB	postgresql-17-extra-window-functions_1.0-7.pgdg13+1_amd64.deb
`postgresql-17-extra-window-functions`	`1.0`	d13.aarch64	pgdg	15.9 KiB	postgresql-17-extra-window-functions_1.0-7.pgdg13+1_arm64.deb
`postgresql-17-extra-window-functions`	`1.0`	u22.x86_64	pgdg	15.6 KiB	postgresql-17-extra-window-functions_1.0-7.pgdg22.04+1_amd64.deb
`postgresql-17-extra-window-functions`	`1.0`	u22.aarch64	pgdg	15.7 KiB	postgresql-17-extra-window-functions_1.0-7.pgdg22.04+1_arm64.deb
`postgresql-17-extra-window-functions`	`1.0`	u24.x86_64	pgdg	15.9 KiB	postgresql-17-extra-window-functions_1.0-7.pgdg24.04+1_amd64.deb
`postgresql-17-extra-window-functions`	`1.0`	u24.aarch64	pgdg	15.9 KiB	postgresql-17-extra-window-functions_1.0-7.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`extra_window_functions_16`	`1.0`	el8.x86_64	pgdg	24.0 KiB	extra_window_functions_16-1.0-3.rhel8.1.x86_64.rpm
`extra_window_functions_16`	`1.0`	el8.aarch64	pgdg	24.0 KiB	extra_window_functions_16-1.0-3.rhel8.1.aarch64.rpm
`extra_window_functions_16`	`1.0`	el9.x86_64	pgdg	24.4 KiB	extra_window_functions_16-1.0-3.rhel9.1.x86_64.rpm
`extra_window_functions_16`	`1.0`	el9.aarch64	pgdg	24.2 KiB	extra_window_functions_16-1.0-3.rhel9.1.aarch64.rpm
`extra_window_functions_16`	`1.0`	el10.x86_64	pgdg	25.1 KiB	extra_window_functions_16-1.0-6PGDG.rhel10.x86_64.rpm
`extra_window_functions_16`	`1.0`	el10.aarch64	pgdg	25.1 KiB	extra_window_functions_16-1.0-6PGDG.rhel10.aarch64.rpm
`postgresql-16-extra-window-functions`	`1.0`	d12.x86_64	pgdg	15.8 KiB	postgresql-16-extra-window-functions_1.0-7.pgdg12+1_amd64.deb
`postgresql-16-extra-window-functions`	`1.0`	d12.aarch64	pgdg	15.8 KiB	postgresql-16-extra-window-functions_1.0-7.pgdg12+1_arm64.deb
`postgresql-16-extra-window-functions`	`1.0`	d13.x86_64	pgdg	15.8 KiB	postgresql-16-extra-window-functions_1.0-7.pgdg13+1_amd64.deb
`postgresql-16-extra-window-functions`	`1.0`	d13.aarch64	pgdg	15.9 KiB	postgresql-16-extra-window-functions_1.0-7.pgdg13+1_arm64.deb
`postgresql-16-extra-window-functions`	`1.0`	u22.x86_64	pgdg	15.6 KiB	postgresql-16-extra-window-functions_1.0-7.pgdg22.04+1_amd64.deb
`postgresql-16-extra-window-functions`	`1.0`	u22.aarch64	pgdg	15.7 KiB	postgresql-16-extra-window-functions_1.0-7.pgdg22.04+1_arm64.deb
`postgresql-16-extra-window-functions`	`1.0`	u24.x86_64	pgdg	15.9 KiB	postgresql-16-extra-window-functions_1.0-7.pgdg24.04+1_amd64.deb
`postgresql-16-extra-window-functions`	`1.0`	u24.aarch64	pgdg	15.9 KiB	postgresql-16-extra-window-functions_1.0-7.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`extra_window_functions_15`	`1.0`	el8.x86_64	pgdg	24.0 KiB	extra_window_functions_15-1.0-2.rhel8.x86_64.rpm
`extra_window_functions_15`	`1.0`	el8.aarch64	pgdg	24.0 KiB	extra_window_functions_15-1.0-2.rhel8.aarch64.rpm
`extra_window_functions_15`	`1.0`	el9.x86_64	pgdg	24.8 KiB	extra_window_functions_15-1.0-2.rhel9.x86_64.rpm
`extra_window_functions_15`	`1.0`	el9.aarch64	pgdg	24.6 KiB	extra_window_functions_15-1.0-2.rhel9.aarch64.rpm
`extra_window_functions_15`	`1.0`	el10.x86_64	pgdg	25.1 KiB	extra_window_functions_15-1.0-6PGDG.rhel10.x86_64.rpm
`extra_window_functions_15`	`1.0`	el10.aarch64	pgdg	25.1 KiB	extra_window_functions_15-1.0-6PGDG.rhel10.aarch64.rpm
`postgresql-15-extra-window-functions`	`1.0`	d12.x86_64	pgdg	15.8 KiB	postgresql-15-extra-window-functions_1.0-7.pgdg12+1_amd64.deb
`postgresql-15-extra-window-functions`	`1.0`	d12.aarch64	pgdg	15.8 KiB	postgresql-15-extra-window-functions_1.0-7.pgdg12+1_arm64.deb
`postgresql-15-extra-window-functions`	`1.0`	d13.x86_64	pgdg	15.8 KiB	postgresql-15-extra-window-functions_1.0-7.pgdg13+1_amd64.deb
`postgresql-15-extra-window-functions`	`1.0`	d13.aarch64	pgdg	15.9 KiB	postgresql-15-extra-window-functions_1.0-7.pgdg13+1_arm64.deb
`postgresql-15-extra-window-functions`	`1.0`	u22.x86_64	pgdg	15.6 KiB	postgresql-15-extra-window-functions_1.0-7.pgdg22.04+1_amd64.deb
`postgresql-15-extra-window-functions`	`1.0`	u22.aarch64	pgdg	15.7 KiB	postgresql-15-extra-window-functions_1.0-7.pgdg22.04+1_arm64.deb
`postgresql-15-extra-window-functions`	`1.0`	u24.x86_64	pgdg	15.9 KiB	postgresql-15-extra-window-functions_1.0-7.pgdg24.04+1_amd64.deb
`postgresql-15-extra-window-functions`	`1.0`	u24.aarch64	pgdg	15.9 KiB	postgresql-15-extra-window-functions_1.0-7.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`extra_window_functions_14`	`1.0`	el8.x86_64	pgdg	24.4 KiB	extra_window_functions_14-1.0-2.rhel8.x86_64.rpm
`extra_window_functions_14`	`1.0`	el8.aarch64	pgdg	23.9 KiB	extra_window_functions_14-1.0-2.rhel8.aarch64.rpm
`extra_window_functions_14`	`1.0`	el9.aarch64	pgdg	24.5 KiB	extra_window_functions_14-1.0-2.rhel9.aarch64.rpm
`extra_window_functions_14`	`1.0`	el10.x86_64	pgdg	25.1 KiB	extra_window_functions_14-1.0-6PGDG.rhel10.x86_64.rpm
`extra_window_functions_14`	`1.0`	el10.aarch64	pgdg	25.1 KiB	extra_window_functions_14-1.0-6PGDG.rhel10.aarch64.rpm
`postgresql-14-extra-window-functions`	`1.0`	d12.x86_64	pgdg	15.7 KiB	postgresql-14-extra-window-functions_1.0-7.pgdg12+1_amd64.deb
`postgresql-14-extra-window-functions`	`1.0`	d12.aarch64	pgdg	15.8 KiB	postgresql-14-extra-window-functions_1.0-7.pgdg12+1_arm64.deb
`postgresql-14-extra-window-functions`	`1.0`	d13.x86_64	pgdg	15.7 KiB	postgresql-14-extra-window-functions_1.0-7.pgdg13+1_amd64.deb
`postgresql-14-extra-window-functions`	`1.0`	d13.aarch64	pgdg	15.8 KiB	postgresql-14-extra-window-functions_1.0-7.pgdg13+1_arm64.deb
`postgresql-14-extra-window-functions`	`1.0`	u22.x86_64	pgdg	15.7 KiB	postgresql-14-extra-window-functions_1.0-7.pgdg22.04+1_amd64.deb
`postgresql-14-extra-window-functions`	`1.0`	u22.aarch64	pgdg	15.7 KiB	postgresql-14-extra-window-functions_1.0-7.pgdg22.04+1_arm64.deb
`postgresql-14-extra-window-functions`	`1.0`	u24.x86_64	pgdg	15.9 KiB	postgresql-14-extra-window-functions_1.0-7.pgdg24.04+1_amd64.deb
`postgresql-14-extra-window-functions`	`1.0`	u24.aarch64	pgdg	15.8 KiB	postgresql-14-extra-window-functions_1.0-7.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`extra_window_functions_13`	`1.0`	el8.aarch64	pgdg	23.8 KiB	extra_window_functions_13-1.0-2.rhel8.aarch64.rpm
`extra_window_functions_13`	`1.0`	el9.aarch64	pgdg	24.3 KiB	extra_window_functions_13-1.0-2.rhel9.aarch64.rpm
`extra_window_functions_13`	`1.0`	el10.x86_64	pgdg	24.9 KiB	extra_window_functions_13-1.0-6PGDG.rhel10.x86_64.rpm
`extra_window_functions_13`	`1.0`	el10.aarch64	pgdg	24.9 KiB	extra_window_functions_13-1.0-6PGDG.rhel10.aarch64.rpm
`postgresql-13-extra-window-functions`	`1.0`	d12.x86_64	pgdg	15.6 KiB	postgresql-13-extra-window-functions_1.0-7.pgdg12+1_amd64.deb
`postgresql-13-extra-window-functions`	`1.0`	d12.aarch64	pgdg	15.6 KiB	postgresql-13-extra-window-functions_1.0-7.pgdg12+1_arm64.deb
`postgresql-13-extra-window-functions`	`1.0`	d13.x86_64	pgdg	15.5 KiB	postgresql-13-extra-window-functions_1.0-7.pgdg13+1_amd64.deb
`postgresql-13-extra-window-functions`	`1.0`	d13.aarch64	pgdg	15.6 KiB	postgresql-13-extra-window-functions_1.0-7.pgdg13+1_arm64.deb
`postgresql-13-extra-window-functions`	`1.0`	u22.x86_64	pgdg	15.6 KiB	postgresql-13-extra-window-functions_1.0-7.pgdg22.04+1_amd64.deb
`postgresql-13-extra-window-functions`	`1.0`	u22.aarch64	pgdg	15.7 KiB	postgresql-13-extra-window-functions_1.0-7.pgdg22.04+1_arm64.deb
`postgresql-13-extra-window-functions`	`1.0`	u24.x86_64	pgdg	15.7 KiB	postgresql-13-extra-window-functions_1.0-7.pgdg24.04+1_amd64.deb
`postgresql-13-extra-window-functions`	`1.0`	u24.aarch64	pgdg	15.6 KiB	postgresql-13-extra-window-functions_1.0-7.pgdg24.04+1_arm64.deb

Source

Repository

github.com/xocolatl/extra_window_functions

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

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

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

Create this extension with:

CREATE EXTENSION extra_window_functions;

Last updated on 2025-11-10

first_last_agg floatvec