Wednesday, September 29, 2010

bizarre __iexact behavior

class KeywordPage(models.Model):

url = models.CharField(blank=False, max_length=100,unique=True)


ipdb> KeywordPage.objects.filter(url__iexact='/path/to/something/')
*** IndexError: list index out of range

ipdb> KeywordPage.objects.filter(url__iexact='/path/to/something')
*** ValueError: list.index(x): x not in list

ipdb> KeywordPage.objects.filter(url__iexact='/path/to/something/')
*** IndexError: list index out of range

ipdb> KeywordPage.objects.filter(url__iexact='why do you care?')
[sql] SELECT ...
FROM "seo_keywordpage"
WHERE UPPER("seo_keywordpage"."url"::text) = UPPER(why DOyou
care?)LIMIT 21
[sql] (1.45ms) Found 0 matching rows
[]


Note that it is in the preparation of these seemingly very simple
queries that django is throwing a bizarre error.

backend is postgres

--
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.

No comments:

Post a Comment