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

Thanks Richard! All is working fine now...

> -----Original Message-----
> From: Richard Broersma Jr [mailto:rabroersma(at)yahoo(dot)com]
> Sent: Friday, November 03, 2006 10:50 AM
> To: robert.balzli
> Cc: General PostgreSQL List
> Subject: RE: [GENERAL] I can not add up columns when using a left
outer
> join. Any ideas as to why?
>
> > 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.
>