>> > You have a DOUBLE column where you need to store NaN? ?Go ahead and >> > store 'NaN' in offending rows. >> >> You mean, as a string? > > No, by binding the raw value using the C interfaces as any > respectable program would do.
But then I'd lose the ability to actually use those values in computations. Also, I'm not particularly fond of SQLite's heterogeneous columns, so I'd like to avoid them. Especially when a much better solution is staring us in the face. > Yes, well, it's been pretty clearly determined that SQLite doesn't > deal with floating point numbers for your definition of "as it should." Great, I am glad that my point got across. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
