Median aggregate

November 12, 2018 ยท View on GitHub

The task of this code is to implement an aggregate function that calculates the median over an input set (typically values from a table). Documentation on how to create aggregates can be found in the official PostgreSQL documentation under User-defined Aggregates

A typical median query is:

SELECT median(temp) FROM conditions;

Compiling and installing

To compile and install the extension:

> make
> make install

Note, that depending on installation location, installing the extension might require super-user permissions.

Testing

Tests can be run with

> make installcheck