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
