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

[Rob Sargent <robjsargent@xxxxxxxxx>]

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.