[Dbix-class] quote char works with sorting without breaking too much!

A. Pagaltzis pagaltzis at gmx.de
Wed Jun 21 17:29:25 CEST 2006


* Ash Berlin <ash at cpan.org> [2006-06-21 17:05]:
> Hows about:
> 
> order_by => [ asc => 'name', 'lastname', desc => {sum => [ 'age' ] } ]
> 
> (A cross between yours and what Jess had)

What’s the point of that arrayref? What does the following mean?

    { sum => [ 'foo', 'bar' ] }

Also, what syntax do folks suggest for specifying something like
the following contrived order clause?

    CASE
        WHEN age < 18 THEN NULL
        WHEN age > 45 THEN NULL
        ELSE age
    END

Or think about writing casts.

Seems pretty pointless to me to invent any syntax beyond
accepting literal SQL…

Regards,
-- 
Aristotle Pagaltzis // <http://plasmasturm.org/>



More information about the Dbix-class mailing list