The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/unaccent.html
Description:
I'm trying to query a database with unaccent, but PostgreSQL gives me
exceptions:
ERROR: function unaccent(character varying) does not exist at character
139
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
STATEMENT: SELECT "cidades"."id", "cidades"."nome", "cidades"."populacao",
"cidades"."estado_id", "cidades"."complemento" FROM "cidades" WHERE
UPPER(UNACCENT("cidades"."nome")::text) LIKE '%' ||
UPPER(REPLACE(REPLACE(REPLACE((UNACCENT('ara')), E'\\', E'\\\\'), E'%',
E'\\%'), E'_', E'\\_')) || '%' ORDER BY "cidades"."nome" ASC LIMIT 21
This query is being generated according to parameters passed by Django.
Example:
cidades.filter(**{'nome__unaccent__icontains': termo_selecao_cidade})