Re: wip: functions median and percentile - Mailing list pgsql-hackers

From Greg Stark
Subject Re: wip: functions median and percentile
Date
Msg-id AANLkTintEz0aPx4pg3c_Y7n6kkfMdgV6gixB_je4fTHf@mail.gmail.com
Whole thread Raw
In response to Re: wip: functions median and percentile  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: wip: functions median and percentile  (Josh Berkus <josh@agliodbs.com>)
Re: wip: functions median and percentile  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On Sun, Oct 10, 2010 at 2:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> It was pointed out upthread that while median isn't presently
> in the standard, Oracle defines it in terms of percentile_cont(0.5)
> which *is* in the standard.

Uhmm, then why don't we implement that? We could provide median() as a
short-cut but percentile_cont() doesn't sound much harder to implement
than median() and more general.

-- 
greg


pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: wip: functions median and percentile
Next
From: Josh Berkus
Date:
Subject: Re: wip: functions median and percentile