-- FUNCTION: public.fnc_retira_acentuacao(text)

DROP FUNCTION public.fnc_retira_acentuacao(text);

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;



UPDATE ctl_menu_nivel SET descricao = TRANSLATE(descricao, '|', '') WHERE parent = 0;