/median.sql

Median function for PostgreSQL

Primary LanguageRuby

Median.sql

Adds a median function to Postgres

Found on postgresonline.com in a comment by Mike.

SELECT median(n) FROM generate_series(1, 5, 1) n;
-- 3

SELECT median(n) FROM generate_series(1, 6, 1) n;
-- 3.5

SELECT median(n) FROM generate_series(1, 0) n;
-- NULL

Installation

Run this SQL