Re: what's wrong with this code?

On Mon, Jun 22, 2015 at 5:12 AM, Jude DaShiell <jdashiel@panix.com> wrote:
> In any case, if it's legal I can probably do the median calculations in an
> easier way or what may be easer.  If the min and max values for each field
> can be inserted into a temporary table under different field names with
> numeric(3,1) types then it ought to be possible to sum the min and max
> values in that temporary table and divide by 2 to get the medians. So far,
> I've not heard of anyone doing anything like this with the min and max
> calculated values.  With my luck though I'd be arrested by the psql Police
> for some violation trying this.

<aside: please try to avoid top posting>

postgres does support median.  see:
http://www.postgresql.org/docs/9.4/static/functions-aggregate.html#FUNCTIONS-ORDEREDSET-TABLE

merlin