[sqlalchemy] Re: RLIKE, REGEXP

2007-10-21 Thread iain duncan
On Wed, 2007-10-10 at 16:41 -0700, jason kirtland wrote: Jim Musil wrote: I don't see support for RLIKE, NOT RLIKE, or REGEXP anywhere. Is there support for this? Yes, you can use these operators and any others via the .op() method: table.c.col1.op('rlike')('re')

[sqlalchemy] Re: RLIKE, REGEXP

2007-10-21 Thread Paul Johnston
Hi, Resource.select_by( foo=bar ) Untested, but I reckon this will work: Resource.query.filter(Resource.foo.op('rlike')('bar')) Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] Re: RLIKE, REGEXP

2007-10-21 Thread Michael Bayer
On Oct 21, 2007, at 4:36 PM, Paul Johnston wrote: Hi, Resource.select_by( foo=bar ) Untested, but I reckon this will work: Resource.query.filter(Resource.foo.op('rlike')('bar')) might need to call op() off the Table instance for now, might not have added op() to the class-based

[sqlalchemy] Re: RLIKE, REGEXP

2007-10-21 Thread iain duncan
On Sun, 2007-21-10 at 17:12 -0400, Michael Bayer wrote: On Oct 21, 2007, at 4:36 PM, Paul Johnston wrote: Hi, Resource.select_by( foo=bar ) Untested, but I reckon this will work: Resource.query.filter(Resource.foo.op('rlike')('bar')) might need to call op() off the

[sqlalchemy] Re: RLIKE, REGEXP

2007-10-10 Thread jason kirtland
Jim Musil wrote: I don't see support for RLIKE, NOT RLIKE, or REGEXP anywhere. Is there support for this? Yes, you can use these operators and any others via the .op() method: table.c.col1.op('rlike')('re') not_(table.c.col1.op('rlike')('re')) table.c.col1.op('regexp')('re') -j

[sqlalchemy] Re: RLIKE, REGEXP

2007-10-10 Thread Eric Lemoine
On 10/11/07, jason kirtland [EMAIL PROTECTED] wrote: Jim Musil wrote: I don't see support for RLIKE, NOT RLIKE, or REGEXP anywhere. Is there support for this? Yes, you can use these operators and any others via the .op() method: table.c.col1.op('rlike')('re')