--DROP FUNCTION public.fnc_retira_acentuacao(text);
	
CREATE OR REPLACE FUNCTION public.fnc_retira_acentuacao(var_dscr text) RETURNS character varying AS $BODY$
DECLARE var_ret character varying(2000);
BEGIN
SELECT TRANSLATE(TRIM(var_dscr),
'áàâãäåaaaÁÂÃÄÅAAAÀéèêëeeeeeEEEÉEEÈìíîïìiiiÌÍÎÏÌIIIóôõöoooòÒÓÔÕÖOOOùúûüuuuuÙÚÛÜUUUUçÇñÑýÝ',
'aaaaaaaaaAAAAAAAAAeeeeeeeeeEEEEEEEiiiiiiiiIIIIIIIIooooooooOOOOOOOOuuuuuuuuUUUUUUUUcCnNyY') 
INTO var_ret;  RETURN var_ret;
END;
$BODY$ LANGUAGE plpgsql VOLATILE COST 100;
ALTER FUNCTION public.fnc_retira_acentuacao(text) OWNER TO postgres;