-- FUNCTION: public.fnc_caracter_invalido(text)

DROP FUNCTION public.fnc_caracter_invalido(text);

CREATE OR REPLACE FUNCTION public.fnc_caracter_invalido(
	var_descricao text)
RETURNS character varying
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE 
AS $BODY$

DECLARE

    var_retorno  character varying(2000);

BEGIN

    SELECT translate(var_descricao, 'áàâãäåaaaÁÂÃÄÅAAAÀéèêëeeeeeEEEÉEEÈìíîïìiiiÌÍÎÏÌIIIóôõöoooòÒÓÔÕÖOOOùúûüuuuuÙÚÛÜUUUUçÇñÑýÝ',
'aaaaaaaaaAAAAAAAAAeeeeeeeeeEEEEEEEiiiiiiiiIIIIIIIIooooooooOOOOOOOOuuuuuuuuUUUUUUUUcCnNyY') 

INTO var_retorno;

   RETURN var_retorno;

END;

$BODY$;

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