Re: Documentation error in tutorial page for Window Functions

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "shineondarkside(at)gmail(dot)com" <shineondarkside(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Documentation error in tutorial page for Window Functions
Date: 2024-11-11 13:39:31
Message-ID: CAKFQuwZhrU11kNDb7+3oMdW9cGfum9X1JMWomZuXU4aE4_d5FQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Sunday, November 10, 2024, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/17/tutorial-window.html
> Description:
>
> In Section 3.5 Window Functions, the sentence that currently says:
> "As shown here, the rank function produces a numerical rank for each
> distinct ORDER BY value in the current row's partition..."
>
> should say:
> "As shown here, the rank function produces a numerical rank for each
> distinct depname value in the current row's partition..."
>
> https://www.postgresql.org/docs/current/tutorial-window.html
>

If we wanted to name the relevant column it would be salary, not depname.
It is the column(s) in the order by that matter here. Or I suppose the
combination of depname and salary. Though it was already covered that each
partition resets all aggregates. Here we are not talking about reset but
when something increments.

David J.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2024-11-11 15:32:55 Re: Improved security for https://www.postgresql.org/docs/current/install-make.html
Previous Message jian he 2024-11-11 01:51:42 Re: Document how to run only specific regress tests