[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