Extensions / Functions and aggregates
Aggregate functions to return first or last "n" elements in a group
pgext.cloud · Documentation · Control file · PGXN
| Package | first_last |
|---|---|
| Version | 0.1.1 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Catalogue updated | 2026-07-30 |
| first_last_agg | first() and last() aggregate functions |
| argm | argmax, argmin, and anyold aggregate functions |
| median | Median aggregate function for input sets |
| frkn_avg | C aggregate extension providing my_avg for bigint and floating-point inputs. |
| trimmed_aggregates | C aggregate functions that discard configurable low/high outliers before computing averages, variances, and standard deviations. |
| pg_agg | Experimental aggregate-query support extension; its install script currently creates the untrusted PL/Python language. |
| kissfft | Fast-Fourier transformer (fft) |
| binvec | C helper for summing integer bit values into arrays |