Unaccent PostgreSQL 8.4

unaccent.sql

-- Adjust this setting to control where the objects get created.
SET search_path = public;

-- Standalone 'unaccent' function

CREATE OR REPLACE FUNCTION unaccent (text) RETURNS text
    AS '/usr/lib64/pgsql/unaccent'
    LANGUAGE C IMMUTABLE STRICT;

-- New 'unaccentdict' dictionary for text search indexer

CREATE OR REPLACE FUNCTION dunaccentdict_init(internal)
    RETURNS internal
    AS '/usr/lib64/pgsql/unaccent'
    LANGUAGE C STRICT;

CREATE OR REPLACE FUNCTION dunaccentdict_lexize(internal, internal, internal, internal)
    RETURNS internal
    AS '/usr/lib64/pgsql/unaccent'
    LANGUAGE C STRICT;

CREATE TEXT SEARCH TEMPLATE unaccentdict_template (
    LEXIZE = dunaccentdict_lexize,
    INIT   = dunaccentdict_init
);

CREATE TEXT SEARCH DICTIONARY unaccentdict (
    TEMPLATE = unaccentdict_template
);

COMMENT ON TEXT SEARCH DICTIONARY unaccentdict IS 'unaccenting dictionary';

unaccented_portuguese.sql

CREATE TEXT SEARCH CONFIGURATION unaccented_portuguese ( COPY = portuguese );
ALTER TEXT SEARCH CONFIGURATION unaccented_portuguese
        ALTER MAPPING FOR hword, hword_part, word
        WITH unaccentdict, portuguese_stem;