[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