On 6 May 2012, at 7:28pm, Petite Abeille <petite.abei...@gmail.com> 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. I'm not sure about a requirement for consistency. NULL isn't a value. It means something like 'value unknown'. Anything attempting to sort columns with nulls in can sort any of the nulls into any position. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
