On Wed, Aug 1, 2012 at 1:03 PM, Naoko <naokoree...@gmail.com> wrote: > QuerySet API - istartswith - use UPPER instead of ILIKE with PostgreSQL > backend > which conflict with Documentation ( > https://docs.djangoproject.com/en/dev/ref/models/querysets/) > as documentation's example shows SQL equivalent as " ILIKE " > > Is this due to my backend being PostgreSQL? or is there setting that I can > change? > I would like to know this so that we can strategize indexing of DB. > Any advice would be appreciated. > > The doc wasn't changed when the optimization for using UPPER instead of ILIKE was put in (see https://code.djangoproject.com/ticket/3575). Feel free to open a ticket against the doc, from a quick check it seems that none of the DB backends use the documented "SQL equivalent". (I wonder if these documented "equivalents" are more trouble than they are helpful...)
Karen -- http://tracey.org/kmt/ -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
