Re: Query plan for "id IS NULL" on PK

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Query plan for "id IS NULL" on PK
Дата
Msg-id 90521e4c-fcb6-f031-37a2-daaa32fee598@gmail.com
обсуждение исходный текст
Ответ на Re: Query plan for "id IS NULL" on PK  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Список pgsql-general
On 2/14/23 15:43, Peter J. Holzer wrote:
On 2023-02-14 15:36:32 -0700, Rob Sargent wrote:
But if the query is supposed to be generic and re-used in a situation where id
could be null, wouldn't the null id records be fetched every time? 
No, they will never be fetched because of the AND (("id" <= ?)).
        hp

Yeah, wanted that back as I hit send.  Sorry.

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

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Query plan for "id IS NULL" on PK
Следующее
От: Brad White
Дата:
Сообщение: Re: Quoting issue from ODBC