> 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.
