Re: UPPER vs. ILIKE for __icontains

2011-10-05 Thread Ted Gruenloh
to use ILIKE vs. LIKE LOWER, though personally I'm not using __icontains so I don't have a dog in this fight :) From: Ted Gruenloh <tedgruen...@yahoo.com> To: "django-developers@googlegroups.com" <django-developers@googlegroups.com> Sent: Tuesd

UPPER vs. ILIKE for __icontains

2011-10-04 Thread Ted Gruenloh
e: On 10/04/2011 05:51 PM, Ted Gruenloh wrote: > The django online documentation mentions that the SQL equivalent for  > __icontains is something like: > >      SELECT ... WHERE headline ILIKE '%Lennon%'; > However, for postgresql - one of the dbs that actually supports ILIKE

[no subject]

2011-10-04 Thread Ted Gruenloh
All: I'm not a Django developer, nor will I pretend to be.  But I did come across something I thought you should be aware of. The django online documentation mentions that the SQL equivalent for  __icontains is something like:     SELECT ... WHERE headline ILIKE '%Lennon%'; However, for