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