On Sun, Oct 10, 2010 at 5:16 PM, Tom Lane <t...@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. What I read in SQL:2008 is that > percentile_cont is defined for all numeric types (returning > approximate numeric with implementation-defined precision), > and for interval (returning interval), and not for any other > input type. So it appears to me that what we ought to support > is > median(float8) returns float8 > median(interval) returns interval > and nothing else --- we can rely on implicit casting to convert > any other numeric input type to float8.
Isn't there a possibility of a precision loss if numeric gets cast to float8? Should we include an explicit variant from numeric? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers