On Mon, Jun 6, 2011 at 9:55 PM, Jean-Christophe Deschamps
<j...@antichoc.net> wrote:

> You have a DOUBLE column where you need to store NaN?  Go ahead and
> store 'NaN' in offending rows.

You mean, as a string? That's rather a dirty hack. Also, it doesn't
work as it should:


sqlite> SELECT 1.0 + 'NaN';
1.0
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to