On Thu, 01 Jun 2006 23:08:13 -0500, Kareem Badr <[EMAIL PROTECTED]> wrote: > Does anyone know what's going on here? Is this just user error?
It's just integer division. D:\sqlite>sqlite3 :memory: SQLite version 3.3.4 Enter ".help" for instructions sqlite> create table bob (f1 varchar, f2 varchar); sqlite> insert into bob values (206140624896,237003182080); sqlite> select sum(f1),sum(f2) from bob; 206140624896|237003182080 sqlite> select sum(f1)/sum(f2) from bob; 0 sqlite> select cast(sum(f1) as double)/cast(sum(f2) as double) from bob; 0.869779988128673 sqlite> klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : [EMAIL PROTECTED] : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+
