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
