Re: null ordering in mysql

Dave: Ah yes *slap in the forehead*. I had forgotten that you could add additional fields using extra() and sort by them. Thanks for your solution. Don: Excellent point. I hadn't considered the behavior of other aggregate functions and things could get quite messy handling the many, different beha

Re: null ordering in mysql

On Dec 14, 2006, at 12:49 AM, MC wrote: > > Problem: > I order dates and null values in ascending order under MySQL. To my > surprise, null values are listed first, then actual dates. Turns out > that in MySQL, null values are LOWER than non-null values, whereas > Postgresql is the reverse. As out

Re: null ordering in mysql

MC wrote: > Problem: > I order dates and null values in ascending order under MySQL. To my > surprise, null values are listed first, then actual dates. Turns out > that in MySQL, null values are LOWER than non-null values, whereas > Postgresql is the reverse. As outlined here > http://troels.arvin

null ordering in mysql

Problem: I order dates and null values in ascending order under MySQL. To my surprise, null values are listed first, then actual dates. Turns out that in MySQL, null values are LOWER than non-null values, whereas Postgresql is the reverse. As outlined here http://troels.arvin.dk/db/rdbms/#select-o