Re: QuerySet API - istartswith - use UPPER instead of ILIKE with PostgreSQL backend

On Wed, Aug 1, 2012 at 1:03 PM, Naoko <naokoreeves@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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.