Re: I can not add up columns when using a left outer join. Any ideas as to why?

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Robert Balzli Jr <robert(dot)balzli(at)xilinx(dot)com>
Cc: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: I can not add up columns when using a left outer join. Any ideas as to why?
Date: 2006-11-03 17:50:04
Message-ID: 5785.98059.qm@web31806.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> COALESCE works great! Is there a way to default the LEFT JOIN to return
> zero and not NULL? Then we could use COALESCE on strings only. Most of
> our columns are integers not strings. This would make our queries
> simpler for 99% of the columns.
> Thanks,
> Robert Balzli
>
> PS: I will join the pgsql-general users group today...

No. you will need to have:

select a, b, coalesce(a,0) + coalesce(b,0)
from your table;

Regards,

Richard Broersma Jr.

PS:
Also, don't forget to use reply all so that everyone one on the list can participate.

Browse pgsql-general by date

  From Date Subject
Next Message Robert Balzli Jr 2006-11-03 17:55:59 Re: I can not add up columns when using a left outer join. Any ideas as to why?
Previous Message Ed L. 2006-11-03 17:46:18 DROP INDEX performance/locking