One of the example queries that 'could' is identical to one that 'could not'.

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: seakintruth(at)gmail(dot)com
Subject: One of the example queries that 'could' is identical to one that 'could not'.
Date: 2021-12-19 12:22:34
Message-ID: 163991655494.26053.16534427118514526140@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/14/indexes-index-only-scans.html
Description:

11.9.2 lists ```SELECT x FROM tab WHERE x = 'key' AND z < 42;``` as both
examples of 'could' and 'could not' use index-only scans. I believe this is
what was meant:
"""""""""""""""""""
but these queries could not:

SELECT x, z FROM tab WHERE x = 'key';
SELECT x FROM tab WHERE x = 'key' AND z < 42;
"""""""""""""""""""

should read:
"""""""""""""""""""
but these queries could not:

SELECT x, z FROM tab WHERE x = 'key';
SELECT z FROM tab WHERE x = 'key' AND z < 42;
"""""""""""""""""""

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2021-12-19 16:15:03 Re: One of the example queries that 'could' is identical to one that 'could not'.
Previous Message Bruce Momjian 2021-12-17 21:43:43 Re: 11.7. Indexes on Expressions