Hallo,



i calculate this in my stored procedure:



sw_a = sum_cntush / anz_cntush / 50.0 * 66.0;

sw_a = double precision, sum_cntush = integer, anz_cntush = integer



Why is the result of sw_a 0? If I change the data type (sum_cntush and
anz_cntush) to double precision, it works fine. Why can this not calculated
with integer?



Thanks in advance.



Olaf







[Non-text portions of this message have been removed]