From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.2.4 serious slowdown |
Date: | 2008-01-14 05:46:15 |
Message-ID: | fmet3q$87c$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Turner | 2008-01-14 05:53:08 | Re: query performance |
Previous Message | pepone.onrez | 2008-01-14 04:59:17 | Re: query performance |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2008-01-14 09:22:01 | Re: Postgresql Materialized views |
Previous Message | Webb Sprague | 2008-01-14 04:54:43 | Re: Postgresql Materialized views |