I want to convert accented characters to the according base character, e.g. "Ü" or "Ú" to "U".
I have the following:
CREATE OR REPLACE FUNCTION unaccent(TEXT) RETURNS TEXT AS $$ use Text::Unaccent; return unac_string('UTF8', $_[0]); $$ LANGUAGE plperlu IMMUTABLE STRICT;
On debian you need the following package: libtext-unaccent-perl