I'm utilizing an sqlite database to keep log data.

My table provides extensive 'real' type posts. After I attempt to execute queries like:

SELECT * FROM log WHERE SomeNumber = 61;
SELECT * FROM log WHERE SomeNumber='61';

It'll return nothing.

Queries like:

SELECT * FROM log WHERE SomeNumber < 10
SELECT * FROM log WHERE SomeNumber > 10

Will return incorrect ranges.

Can there be a problem with my syntax ?

Thanks,

It truly is dependent on which you place to your table. Real amounts are nearly always globally tricky. A "real" worth of 61 may be saved as 61.0000000000001. The fundamental premise is, if you want to look for equality, prefer integers.

You might like to try:

SELECT * FROM log WHERE SomeNumber = 61.0;

It could also rely on just how much precision you joined your original value with.

NB: I ought to explain that normally, an integer value like 61 is saved precisely even while a genuine. Case a simplification.