At 09:18 PM 22/05/2011, Olaf Kluge wrote:

>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?

SQL standard: integer / integer -> integer

./hb