Wednesday, August 1, 2012

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

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.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/X63mnnoHTvwJ.
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.

No comments:

Post a Comment