desacentua.sql

-- Function: desacentua(character varying)

-- DROP FUNCTION desacentua(character varying);

CREATE OR REPLACE FUNCTION desacentua(texto character varying)
  RETURNS character varying AS
$BODY$
SELECT translate( $1,'ÁÉÍÓÚÀÈÌÒÙÃÕÂÊÎÔÛÄËÏÖÜÇÑáéíóúàèìòùãõâêîôûäëïöüçñ','AEIOUAEIOUAOAEIOUAEIOUCNaeiouaeiouaoaeiouaeioucn')
$BODY$
  LANGUAGE sql IMMUTABLE
;