Re: 8.2.4 serious slowdown

(attribution restored)
Clodoaldo wrote:
>  > I don't know if the plan would be the same but this is a bit clearer:
>  >
>  > WHERE COALESCE(b.quantity, 0) > COALESCE(b.deliveredsum, 0)

Sim Zacks wrote:
> That should be true, but sometimes we get deliveries of greater quantity
> then we ordered.
> I just want to know the times when I haven't gotten the complete order yet.
> If we get more then we ordered, I don't want it to be in this query.

Huh?

How does that relate to the suggestion?

The suggested expression is mathematically equivalent to and perfectly
substitutable for the original.

--
Lew