NaN, Null, and Sorting

[MRAB]

On 13/01/2012 19:58, Chris Angelico wrote:
> On Sat, Jan 14, 2012 at 6:04 AM, Ethan Furman<ethan at stoneleaf.us>  wrote:
>>  So I am strongly leaning towards implementing the comparisons such that Null
>>  objects are less than other objects so they will always sort together.
>
> This is a perfectly plausible view, and is the one adopted by SQL (I'm
> pretty sure the "NULLS FIRST" / "NULLS LAST" clause is standard - you
> get to choose whether they're less than everything or more than
> everything).
>
+1