Problems when using unaccent

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: jansenmauro(at)gmail(dot)com
Subject: Problems when using unaccent
Date: 2024-01-02 04:12:30
Message-ID: 170416875036.1876504.6115717514007667066@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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})

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2024-01-02 16:43:59 Re: Problems when using unaccent
Previous Message Tom Lane 2024-01-01 19:23:58 Re: Postgres compilation instructions do not work on modern debian or ubuntu