[Dbix-class] lower on column and query
Emmanuel Quevillon
tuco at pasteur.fr
Fri Feb 29 09:43:08 GMT 2008
Hi,
I'd like to perform a query where I'd like to cal SQL
funciton on :
select * from foo where lower(field) = lower(query).
So I wondered if from a ResultSet::search method I could
pass attribute like 'case => lower' as described in
SQL::Abstract::new method?
BTW, I am using PostGreSQL
Thanks
Emmanuel
--
-------------------------
Emmanuel Quevillon
Biological Software and Databases Group
Institut Pasteur
+33 1 44 38 95 98
tuco at_ pasteur dot fr
-------------------------
More information about the DBIx-Class
mailing list