Anybody thought of:
t1.a = 5
t1.b = 2
select a / (b * 1.0);
I think that would return a real.
-----Original Message-----
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Friday, September 30, 2005 11:10 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Problem/Bug: "SELECT 5 / 2;" returns 2 ?
Ralf Junker wrote:
>>This can be fixed by checking the column affinity for a value when it
is stored. If an integer value is being stored in a column with numeric
affinity, then store the value as a REAL value
...
