Re: [sqlite] Problem/Bug: "SELECT 5 / 2;" returns 2 ?

[Lawrence Chitty]

Ralf Junker wrote:

In risk of asking the obvious, I wonder if the following division should be 
considered correct:
 | Query             | Result Value | Result Type    | OK?
-----------------------------------------------------------
1 | SELECT 5 / 2;     | 2            | SQLITE_INTEGER | No?
 

I am following the rest of this thread, but just wanted to add that the 
following may be useful as a workaround for your situation.

SELECT  ROUND(5) / 2
2.5

Regards

Lawrence