Apparently I was suffering from brain freeze.
sim
Lew wrote:
> (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.
>