Comment by taffer

Window functions can be used to compute the median:

    select percentile_disc(0.5) within group (order by things.value)
    from things