On Sep 27, 2013, at 12:39 PM, Jonathan Vanasco <jonat...@findmeon.com> wrote:
> Any progress on considering:
>
> * icontains
> * istartswith
> * iendswith
>
> I ran into this again ( i had posted a similar request about a year or so ago
> )
>
> re "But then what do we do on a backend that doesn't have "ilike"? do we
> raise an error? "
>
> would this be possible:
>
> .filter( User.name.icontains('ADAM') )
>
> supports ilike -- """ WHERE name ilike '%ADAM%' """
> no ilike -- """ WHERE LOWER(name) like LOWER('%ADAM%') """ [ or """ WHERE
> LOWER(name) like '%adam%' """ ]
>
>
> at least i think most backends support LOWER on evaluation.
yeah im not sure why I asked that, i wonder if the current ilike() does that
anyway.
I'm +1 on "case_sensitive=None" by default, it should accept False, but i think
perhaps it *shouldn't* accept "True" since we can't really control that.
signature.asc
Description: Message signed with OpenPGP using GPGMail
