Re: wip: functions median and percentile

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>

To: "David Fetter" <david@fetter.org>, "Pavel Stehule" <pavel.stehule@gmail.com>

Cc: "Robert Haas" <robertmhaas@gmail.com>, "Greg Stark" <gsstark@mit.edu>, "PostgreSQL Hackers" <pgsql-hackers@postgresql.org>, "Tom Lane" <tgl@sss.pgh.pa.us>

Date: 2010-08-19T18:17:28Z

Lists: pgsql-hackers

Pavel Stehule <pavel.stehule@gmail.com> wrote:
 
> I looked there and Oracle11g use "median" in common sense.
 
As does Sybase IQ.  FWIW, Excel spreadsheets do, too.
 
The chance of the SQL committee picking some other meaning for bare
MEDIAN seems vanishingly small; although I have to grant that with
only Oracle and Sybase as a precedent in the SQL world, it's not
zero.
 
-Kevin