> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
