i dont like to add vendor-specific syntax to the base library. although, ILIKE wins the prize for the most requested vendor-specific syntax.
the "op" function is designed to handle all the operators that arent built in, such as: mytable.c.somecolumn.op('ILIKE')("something") On Sep 14, 2006, at 2:38 AM, Enrico Morelli wrote: > Dear all, > > I'm using SQLAlchemy with PostgreSQL. I needed to use the ILIKE > command, so I had modified the sql.py file including the lines: > > def ilike(self, other): > return self._compose('ILIKE', other) > > It seems to works well. Is it enough or there are other files to > modify? > Is it possibile to include it in the new versions of SQLAlchemy? > > Thanks > > -- > ------------------------------------------------------------------- > (o_ > (o_ //\ Coltivate Linux che tanto Windows si pianta da solo. > (/)_ V_/_ > +------------------------------------------------------------------+ > | ENRICO MORELLI | email: [EMAIL PROTECTED] | > | * * * * | phone: +39 055 4574269 | > | University of Florence | fax : +39 055 4574253 | > | CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY | > +------------------------------------------------------------------+ > > ---------------------------------------------------------------------- > --- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your > job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel? > cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users