Thanks for the quick response. That was what I was expecting. Regards, Donald.
On 4 March 2014 15:20, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Mar 3, 2014 at 11:14 PM, Donald Shepherd > <donald.sheph...@gmail.com>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 > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
