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 - I noticed __icontains was actually performing something similar to: SELECT ... WHERE LOWER(headline) LIKE LOWER('%Lennon%'); The ILIKE is obviously much faster [...]
https://code.djangoproject.com/ticket/3575 -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.
