Calculating the median

[Daniel Hocking]

There was a previous question that asked if certain aggregate functions like percentile_cont could be used, from some testing it seems the version of pgsql used on grieg doesn't support that function so that's the easy way to calculate median out. 

Another method might used limit and offset but the instructions say that limit can't be used either. 

I can think of some other significantly less efficient methods to determine the median but I'm just wondering if I'm missing something obvious on my first two points?

[Zhe Zhang]

Hi~ previous "questioner" here, seems the percentile_cont is support from v9.4 but we are in 9.3.3~

So I guess we need to find it out manually.

[Daniel Krishnapillai]

You've probably figured out another way by now, but you could possibly use 'offset' and 'fetch next' to calculate the median