Piotr Wadas wrote: > > Note the following from > > http://www.postgresql.org/docs/8.3/static/functions-aggregate.html > > "It should be noted that except for count, these functions return a null > value when no rows are selected. In particular, sum of no rows returns null, > not zero as one might expect. The coalesce function can be used to > substitute zero for null when necessary." > > So probably, the query should be modified according to COALESCE description > (?)
Yep. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman-new.icns.fastxs.net/cgi-bin/mailman/listinfo/dbmail-dev
