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
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
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
3 matches
Mail list logo
