Re: [sqlite] Integer / Numeric calculations

[A. Pagaltzis]

* Mikey C <[EMAIL PROTECTED]> [2006-05-22 08:00]:
> If have tried cast both rating and votes and the result to NUMERIC but still
> an integer.

Cast one of them to REAL.

    SELECT CAST( rating AS REAL ) / votes FROM foo; 

Regards,
-- 
Aristotle Pagaltzis // <http://plasmasturm.org/>