Re: Full text index without accents

Jonathan Bond-Caron wrote:
> This would probably help:
>
> CREATE OR REPLACE FUNCTION norm_text_latin(character varying)
>   RETURNS character varying AS
> $BODY$
> declare
>     p_str        alias for $1;
>     v_str        varchar;
> begin
>     select translate(p_str, 'ÀÁÂÃÄÅ', 'AAAAAA') into v_str;

Hmm, why not simply use to_ascii() ?



--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support