On 27 Mar 2012, at 3:12am, Jay A. Kreibich <j...@kreibi.ch> wrote: > On Sun, Mar 25, 2012 at 05:48:01AM +0100, Simon Slavin scratched on the wall: > >> Can those values be passed from a 'double' C variable ? I believe so. >> So I see no reason why SQLite shouldn't be storing them. > > If, in the sense of "can I arrange the bits that way", then yes. > However, in the sense of "is this a valid floating point number?" the > answer is no.
Okay. That's the heart of the matter: what do we mean by "REAL" in the documentation. The word "REAL" right next to "IEEE" makes me think it handles NaN, +Inf and -Inf. But it's not explicitly stated. So fair point: if you don't claim to handle NaN then you don't have to. Still, the matter having come up, and us having thrashed it out, I do think it's worth mentioning what happens with the three 'special' values. Or removing all mention of IEEE entirely. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
