On 06-05-2012 20:28, Petite Abeille wrote: > > On May 6, 2012, at 8:18 PM, Luuk wrote: > >> So, if it is not defined how to sort column b, >> how can anyone correctly sort the column a? > > While the standard itself might well have nothing helpful to say about how a > null value should be sorted by default ( NULLS FIRST or NULLS LAST), a given > implementation (e.g. SQLite) will have an opinion about it. That opinion > should be consistent. And it appears it's not. Which would qualify as an > anomaly. >
The NULLS FIRST or NULLS LAST is about if the NULLs should be before, or after the 'other' data. It does not say anything about how to sort the fields which all have the 'value' NULL sqlite> .null (NULL) sqlite> select NULL or NULL; (NULL) sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
