On 2/14/23 15:30, David G. Johnston wrote:
> On Tue, Feb 14, 2023 at 3:25 PM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
>
> When will id be null in a primary key?
>
>
> The OP seems to be aware of this...
>
> "We cannot change the query being executed. Is there any way we can
> make the query planner ignore `OR (id IS NULL)` (as that will never be
> the case for the PK) and use both `id` clauses in the index condition?"
>
> David J.
>
Yes, agreed.
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?