On 3/24/16 9:00 AM, Konstantin Knizhnik wrote:
> But unfortunately it is not possible to calculate median is such way
> because percentile_disc is not compatible with OVER:
I don't know if you could use cume_dist()[1] to do this, but even if you
can't it probably wouldn't be hard to modify it to do what you need.
[1] http://www.postgresql.org/docs/9.5/static/functions-window.html
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com