[PonyORM-list] Case sensitivity with "in"

[Alexander Kozlovsky]

Hi Matthew,

try this:

    Entity.select(lambda e: "pony" in e.title.lower())

Should work for all supported databases



On Tue, Jun 10, 2014 at 6:56 PM, Matthew Bell <matthewrobertbell at gmail.com>
wrote:

> Hi,
>
> I havea query like:
>
> Entity.select(lambda e: "pony" in e.title)
>
> I need this to be case insenstivive, I'm using Postgres if that matters.
> Is this currently possible with pony? If not, is it possible to hack a
> query before it executes (to use ILIKE) ?
>
> Thanks
>
> --
> Regards,
>
> Matthew Bell
>
> _______________________________________________
> ponyorm-list mailing list
> ponyorm-list at ponyorm.com
> /ponyorm-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </ponyorm-list/attachments/20140610/7a2ed692/attachment.html>