first_last_agg
first() and last() aggregate functions
Module:
Categories:
Overview
MIXED 3rd Party Extension: first_last_agg
: first() and last() aggregate functions
Information
- Extension ID: 4710
- Extension Name:
first_last_agg
- Package Name:
first_last_agg
- Category:
FUNC
- License: PostgreSQL
- Website: https://github.com/wulczer/first_last_agg
- Language: C
- Extra Tags: N/A
- Comment: N/A
Metadata
- Latest Version: 0.1.4
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION
DDL - Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
first_last_agg_$v
- RPM Ver :
0.1.4
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-first-last-agg
- DEB Ver :
0.1.4
- DEB Deps: N/A
Packages
Installation
Install first_last_agg
via the pig
CLI tool:
pig ext install first_last_agg
Install first_last_agg
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["first_last_agg"]}' # -l <cls>
Install first_last_agg
RPM from YUM repo directly:
dnf install first_last_agg_17;
dnf install first_last_agg_16;
dnf install first_last_agg_15;
dnf install first_last_agg_14;
dnf install first_last_agg_13;
Install first_last_agg
DEB from APT repo directly:
apt install postgresql-17-first-last-agg;
apt install postgresql-16-first-last-agg;
apt install postgresql-15-first-last-agg;
apt install postgresql-14-first-last-agg;
apt install postgresql-13-first-last-agg;
Enable first_last_agg
extension on PostgreSQL cluster:
CREATE EXTENSION first_last_agg;
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.