Re: Index ordering after IS NULL

On Sat, Sep 10, 2022 at 2:28 PM Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> explain analyze select * from j where b is null order by c limit 10;
> explain analyze select * from j where b =8 order by c limit 10;
>
> The first uses a sort despite it being disabled.

The first/is null query seems to give the result and plan you're
looking for if the query is rewritten to order by "b, c", and not just
"c".

That in itself doesn't make your complaint any less valid, of course.
You don't have to do this with the second query, so why should you
have to do it with the first?

--
Peter Geoghegan