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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
