NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
use Perl Log In
bpphillips (5948)
+
-
Comments:
4
Comment: are you sure that works? (Score 1) on 2009.12.07 13:56
Shouldn't it be (as it appears was suggested in your earlier post):
If the coalesce is outside the sume, it doesn't fix the underlying issue of apply an aggregate function on a set of data that may contain a NULL value. Or, perhaps I'm missing something...
Read More
4 comments
SUM( COALESCE( price, 0 ) ) AS total
If the coalesce is outside the sume, it doesn't fix the underlying issue of apply an aggregate function on a set of data that may contain a NULL value. Or, perhaps I'm missing something...
--Larry Wall
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.