Re: [sqlite] Float comparision problem

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

[sqlite] Float comparision problem

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