On 1 Aug 2011, at 9:47pm, Igor Sereda wrote: > So - who else thinks it's a bug?
The SQL standard says 'NULL' means 'I don't know' or 'value missing' or something of the kind. So using a comparison like X > NULL doesn't mean anything, since there can't be a well-ordering principle for a missing value since there's nothing to compare it to. By the way, the recommended way to do what the original line of code does seems to be to use 'typeof(X)'. But I don't know how a beginner SQLite user is expected to know that. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
