| From: | Lew <lew(at)lwsc(dot)ehost-services(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 8.2.4 serious slowdown |
| Date: | 2008-01-13 17:04:29 |
| Message-ID: | epidnYENtJ0D2RfanZ2dnUVZ_vzinZ2d@comcast.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-13 17:25:47 | Re: tcp_keepalives_idle ignored |
| Previous Message | henry | 2008-01-13 16:53:09 | Re: tcp_keepalives_idle ignored |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2008-01-13 17:05:13 | Re: Make pg_dump suppress COMMENT ON SCHEMA public ? |
| Previous Message | Alvaro Herrera | 2008-01-13 16:52:40 | Re: Postgresql Materialized views |