[sqlalchemy] is there a reason why lower() isn't a column operation ?

2012-08-13 Thread Jonathan Vanasco
just wondering why i have to do : sqlalchemy.sql.func.lower( class.column ) == string.lower() instead of : class.column.lower() = string.lower() btw - i know in the archives people have mentioned doing an ilike search, but a WHERE lower(column) = 'string' search will search against a

Re: [sqlalchemy] is there a reason why lower() isn't a column operation ?

2012-08-13 Thread Michael Bayer
On Aug 13, 2012, at 1:44 PM, Jonathan Vanasco wrote: just wondering why i have to do : sqlalchemy.sql.func.lower( class.column ) == string.lower() instead of : class.column.lower() = string.lower() btw - i know in the archives people have mentioned doing an ilike search, but a