select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Functions and aggregates

median

Median aggregate function for input sets

pgext.cloud · Source code · Documentation · Control file

Overview

Packagemedian
Version1.0
PostgreSQL versions10 · 11 · 12
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars1
Latest commit2020-12-15
Catalogue updated2026-08-30

Related extensions

See also

pg_median_utilsMedian filter and iterative median filter window functions for PostgreSQL
argmargmax, argmin, and anyold aggregate functions
pg_etagFast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates.
frkn_avgC aggregate extension providing my_avg for bigint and floating-point inputs.
first_lastAggregate functions to return first or last "n" elements in a group
trimmed_aggregatesC aggregate functions that discard configurable low/high outliers before computing averages, variances, and standard deviations.
pg_aggExperimental aggregate-query support extension; its install script currently creates the untrusted PL/Python language.
kissfftFast-Fourier transformer (fft)