CODEWITHSUNDEEP
pythondjangodjango-models
Tony Lâmpada
Tony Lâmpada

Reputation: 5459

Django: filter query using database function

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') ?

Upvotes: 2

Views: 439

Answers (1)

catavaran
catavaran

Reputation: 45565

Use queryset's extra() method:

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

Upvotes: 3

Related Questions