sumKahan
Calculates the sum of the numbers with Kahan compensated summation algorithm Slower than sum function. The compensation works only for Float types.
Syntax
sumKahan(x)
Arguments
Returned value
Example
Query:
SELECT sum(0.1), sumKahan(0.1) FROM numbers(10);
Result:
ββββββββββββsum(0.1)ββ¬βsumKahan(0.1)ββ
β 0.9999999999999999 β 1 β
ββββββββββββββββββββββ΄ββββββββββββββββ