Median missing from aggregate functions page

Started by Steven Winfieldover 9 years ago2 messagesdocs
Jump to latest
#1Steven Winfield
Steven.Winfield@cantabcapital.com

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/functions-aggregate.html
Description:

The index contains an entry for "median" on the aggregate functions page,
but there is no mention of it there.

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Steven Winfield (#1)
Re: Median missing from aggregate functions page

steven.winfield@cantabcapital.com writes:

The index contains an entry for "median" on the aggregate functions page,
but there is no mention of it there.

Hm --- that <indexterm> entry is attached to the percentile_cont()
function, which can be used to implement median, but I agree that
a person who already knew that would probably not be following the
index pointer.

It might be more useful to point to 4.2.7. Aggregate Expressions
which contains a concrete example of how to implement median
with percentile_disc().

Another idea is to just make the index entry say
"See percentile_cont() and percentile_disc()".

regards, tom lane

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs