On Sat, Sep 1, 2012 at 12:07 PM, David Johnston <polobo@xxxxxxxxx> wrote: > These are not equivalent if some values of foo are not-null and you want the sum of all non-null values while replacing any nulls with zero. So the decision depends on what and why you are summing. It comes to the same result with SUM though isn't it? ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
