[EMAIL PROTECTED] wrote:
Did you try sum(a)/count(a) instead of avg(a).
SQLite version 3.3.3
Enter ".help" for instructions
sqlite> create table t (a integer, b real);
sqlite> insert into t values (3, 3);
sqlite> insert into t values (3, 3);
sqlite> insert into t values (4, 4);
sqlite> select avg(a), sum(a)/count(a) from t;
3.33333333333333|3
Kind of seems wrong, doesn't it....
--
D. Richard Hipp <[EMAIL PROTECTED]>
Richard,
This is a good point. This is exactly the kind of consistency that the
standard developers try hard to eliminate. It's probably one of the
reasons the standard says the average of an integer column should be an
integer (or words to that effect).
Dennis Cote
