Extensions
extra_window_functions

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
first_last_aggfloatvec