Hi,
I have created a table with the following values.....
CREATE TABLE [test] ([Id] TEXT DEFAULT(0), [PV] REAL DEFAULT(0));
insert into [test] ("Id", "PV") values ('485314EL', '-720.237');
insert into [test] ("Id", "PV") values ('485314L', '-720.237');
insert into [test] ("Id", "PV") values ('485314LE', '720.237');
insert into [test] ("Id", "PV") values ('485440EL', '-720.237');
insert into [test] ("Id", "PV") values ('485440L', '-720.237');
insert into [test] ("Id", "PV") values ('485440LE', '720.237');
insert into [test] ("Id", "PV") values ('522116EL', '720.237');
insert into [test] ("Id", "PV") values ('522116L', '720.237');
insert into [test] ("Id", "PV") values ('522116LE', '-720.237');
insert into [test] ("Id", "PV") values ('522122EL', '720.237');
insert into [test] ("Id", "PV") values ('522122L', '720.237');
insert into [test] ("Id", "PV") values ('522122LE', '-720.237');
However when I execute a SUM against this table I get an incorrect
value. The query I use is
SELECT SUM([PV] ) from [test]
The returned value is 2.2737e-13 instead of 0.
Can anyone shed some light?
Sent from my BlackBerry® wireless device
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
