Sort order with null placement (NULLS FIRST, NULLS LAST)
Added ability to sort with null placement. Sometimes it's very useful.
Tested on sqlite3, mysql, firebird, postgres.
#1 Updated by Mischa The Evil almost 2 years ago
I find this interesting, but I don't know if this is something that is (going to be) widely used (thus not being something that might fit the core). At least, I haven't seen requests for this before. Could you maybe provide some use-case(s) describing where and how this could be used and to what purposes? And could you please provide some tests for this feature?
#2 Updated by Andrey Lobanov (RedSoft) almost 2 years ago
I'll certianly add some tests a bit later.
So in my company projects some fields can be null, and default sort order on this fields will put not null values at the end, and null values at the top. So this feature allows you to put null values in wanted place.