Thanks Richard! All is working fine now... > -----Original Message----- > From: Richard Broersma Jr [mailto:rabroersma@xxxxxxxxx] > 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. >
