Hi thanks for answer,
maybe it would be good to have a sum_null() function to deal with my case ?
because logically speaking, when a value is null in an operation the result
is null, this is the case for normal functions in mysql (ie not "group by"
function)
i think it is perfect sense that cou
At 6:23 +0200 3/31/02, pascal barbedor wrote:
>- Original Message -
>From: pascal barbedor
>To: [EMAIL PROTECTED]
>Sent: Sunday, March 31, 2002 6:19 AM
>Subject: sum() autoconvert null to zero
>
>
> Egor,
>
>>Null is an unidentified value, but MySQL
- Original Message -
From: pascal barbedor
To: [EMAIL PROTECTED]
Sent: Sunday, March 31, 2002 6:19 AM
Subject: sum() autoconvert null to zero
Egor,
>Null is an unidentified value, but MySQL will store 0 or ''. You can read
about
>it at:
> http://www.mysql.com/doc
pascal,
Friday, March 29, 2002, 2:53:23 PM, you wrote:
pbln> in mysql 3.23.45
pbln> I have a numeric field N with null values allowed and null
pbln> values in some rows of the database
pbln> when i ask select sum(N) from table
pbln> the result is the sum of non null values (like if null va
hi
in mysql 3.23.45
I have a numeric field N with null values allowed and null
values in some rows of the database
when i ask select sum(N) from table
the result is the sum of non null values (like if null values
converted to zero) and not "null" as expected for a sum of
values with null i
