Inconsistent information on default ordering for ORDER BY clause

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: duffieldzane(at)gmail(dot)com
Subject: Inconsistent information on default ordering for ORDER BY clause
Date: 2023-12-08 04:05:15
Message-ID: 170200831532.398198.10492594033145816767@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

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).

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David Rowley 2023-12-08 09:56:48 Re: Inconsistent information on default ordering for ORDER BY clause
Previous Message Bruce Momjian 2023-12-08 02:36:13 Re: [DOCS] Confusing Trigger Docs.