Search Postgresql Archives

Re: 8.2.4 serious slowdown

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux