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

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема One of the example queries that 'could' is identical to one that 'could not'.
Дата
Msg-id 163991655494.26053.16534427118514526140@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: One of the example queries that 'could' is identical to one that 'could not'.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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;
"""""""""""""""""""

В списке pgsql-docs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: 11.7. Indexes on Expressions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: One of the example queries that 'could' is identical to one that 'could not'.