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

Reply via email to