PG Bug reporting form <noreply@postgresql.org> writes:
> I have recently created a partial index on tables like following
> create index unprocessed_order_index
> on order (creation_date) where processed is false;
> When I am querying the table using processed = false like below, the index
> is not used
> I was expecting to treat both = and is same, or am I wrong
IS and = are not the same. You could argue that they have the same effect
in this particular case, but there's no logic in the planner that would
deduce that.
regards, tom lane