Floating point representation issues. This is nothing out of the ordinary, expect stuff like that to happen in any programming language on any system. See David Goldberg's seminal paper "What Every Computer Scientist Should Know About Floating-Point Arithmetic" here for details: http://docs.sun.com/source/806-3568/ncg_goldberg.html
On 07/25/2009 01:32 AM, Guidosss wrote: > Hi, i need some help... what i am doing wrong?? > > This works fine > SELECT 1 > WHERE CAST(14.8 AS REAL) = CAST(14.8 AS REAL) > > But this doesn't > SELECT 1 > WHERE CAST(14.8 AS REAL) = CAST(0.1+14.7 AS REAL) > > Thanks. > _______________________________________________ > 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
