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