CREATE OR REPLACE FUNCTION public.fnc_retira_acentuacao(
	var_dscr text)
    RETURNS character varying
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE PARALLEL UNSAFE
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$;

ALTER FUNCTION public.fnc_retira_acentuacao(text)
    OWNER TO postgres;