Django: filter query using database function

Question

I have a unnaccent_string function in my postgres database like described here: comparing strings in PostgreSQL

so that

unnaccent_string(órfão) == 'orfao'

Is it possible to build a Django QuerySet that would let me do something like Person.objects.filter(unnaccent_string(name)__icontains='joao') ?

score 3 · Accepted Answer · answered Jan 27 '15 at 12:59

3

Use queryset's extra() method:

Person.objects.extra(where=['unnaccent_string(name) LIKE %s'),
                     params=['%joao%'])

answered Jan 27 '15 at 12:59

catavaran

1

Hey Tony! I'd sugestão you to wrap this option in a custon manager in order to avoid passing só many arguments every time. – Rômulo Collopy Jan 27 '15 at 17:16

1 Answers1