Postgres Pro
Downloads
Home   >   mailing lists

Re: Query plan for "id IS NULL" on PK - Mailing list pgsql-general

From Rob Sargent
Subject Re: Query plan for "id IS NULL" on PK
Date
Msg-id 90521e4c-fcb6-f031-37a2-daaa32fee598@gmail.com
Whole thread Raw
In response to Re: Query plan for "id IS NULL" on PK  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Tree view
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 by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Query plan for "id IS NULL" on PK
Next
From: Brad White
Date:
Subject: Re: Quoting issue from ODBC