Thanks for the quick response. That was what I was expecting. Regards, Donald.
On 4 March 2014 15:20, Richard Hipp <[email protected]> wrote: > On Mon, Mar 3, 2014 at 11:14 PM, Donald Shepherd > <[email protected]>wrote: > > > It appears that using equals on floating point (REAL) data in WHERE > clauses > > doesn't necessarily work, presumably because of rounding errors - see > below > > for an example. Is this the case? Do I need to use BETWEEN instead of = > > as I expect to be the case? > > > > Never (well, almost never) use == with floating point numbers. This rule > applies to all systems, not just SQLite. > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
