Aggregate Median - PostgreSQL wiki

NOTE: This page is obsolete. To get the median in PostgreSQL, use percentile_cont(0.5) WITHIN GROUP (ORDER BY num_value). See the documentation for more details. However ordered-set aggregates cannot be used as Window functions, while the alternatives given below can be. The statistical median is the numerical value separating the higher half of a data sample, a population, or a probability distri

[EulerDijkstra]

postgreでmedian実装