Thread: [DOCS] Median missing from aggregate functions page

[DOCS] Median missing from aggregate functions page

From
steven.winfield@cantabcapital.com
Date:
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.

Re: [DOCS] Median missing from aggregate functions page

From
Tom Lane
Date:
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