[Dbix-class] Re: NULLS FIRST

[Dagfinn Ilmari Mannsåker]

Bill Moseley <moseley at hank.org> writes:

> I have some code that builds up hash references of sort keys.
>
> order_by => [
>     {  -desc => 'value' },
>     {  -asc => 'modified_time' },
> ],
>
>
> Is there support for NULLS { FIRST | LAST } with that syntax?

There isn't currently. There's rudimentary support in git branches of
SQL::Abstract¹ and DBIx::Class², but because several of the limit dialects
require mangling the ordering clause of the original query, this can't
really be done sensibly until the porting to Data::Query is done.

[1] http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits/SQL-Abstract.git;a=commitdiff;h=refs/heads/order-by-nulls

[2] http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits/DBIx-Class.git;a=commitdiff;h=refs/heads/wip/order_by_nulls_dbic_portion

-- 
"A disappointingly low fraction of the human race is,
 at any given time, on fire." - Stig Sandbeck Mathisen