>> That particular formula cannot handle ANY non-positive number because >> the LOG() function is undefined for values less than or equal to zero. >> I just reviewed the archives and realized that this point has never >> been discussed before (I thought it had). Good catch. well, the slow and dirty formula would be IF(SUM(IF(n=0,1,0))>0,0,EXP(SUM(LOG(ABS(COALESCE(n,1)))))*POWER(-1,SUM(IF(n<0,1,0))))
which simply aggregates the signs and zeroes. here n is the field to multiply. a more performant solution would be a little udf-function.
ciao, konrad
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
