Re: Inconsistent information on default ordering for ORDER BY clause

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: duffieldzane(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Inconsistent information on default ordering for ORDER BY clause
Date: 2023-12-08 09:56:48
Message-ID: CAApHDvoV-gaKcZmOwChZOVoLfqfEHh5KBpuwh7Sx8u9iSDS8YA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Fri, 8 Dec 2023 at 22:49, PG Doc comments form
<noreply(at)postgresql(dot)org> wrote:
> Page: https://www.postgresql.org/docs/16/sql-select.html
> Description:
>
> At the top of the sql-select page it says
>
> "If ORDER BY is not given, the rows are returned in whatever order the
> system finds fastest to produce."
>
> but later it says
>
> "Optionally one can add the key word ASC (ascending) or DESC (descending)
> after any expression in the ORDER BY clause. If not specified, ASC is
> assumed by default."
>
> The first statement implies that you cannot rely on the default ordering,
> but the second implies that you can (and it will be ASC).

Perhaps you're going wrong in the last sentence in the latter fragment
where it says "If not specified". This is talking about ASC/DESC
rather than the ORDER BY.

Maybe that could be made more clear. Something like "If ASC or DESC is
not specified, ASC is assumed by default".

Would that make it more clear?

David

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Zane Duffield 2023-12-08 10:18:45 Re: Inconsistent information on default ordering for ORDER BY clause
Previous Message PG Doc comments form 2023-12-08 04:05:15 Inconsistent information on default ordering for ORDER BY clause