[sqlite] Sqlite SUM erroneous return value

Sent from my BlackBerry® wireless device -Original Message- From: Van Ry, Wayne [EMAIL PROTECTED] Date: Wed, 4 Jun 2008 14:17:33 To:[EMAIL PROTECTED] Subject: FW: Sqlite SUM erroneous return value __ From: Van Ry, Wayne

[sqlite] Sqlite SUM erroneous return value

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',

Re: [sqlite] Sqlite SUM erroneous return value

On Jun 4, 2008, at 6:18 AM, [EMAIL PROTECTED] wrote: 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',