CREATE FUNCTION dim_directornew_name() RETURNS trigger AS $dim_director_name$
    BEGIN
        -- Check that empname and salary are given
        IF NEW.name like 'Manuel de Oliveira' OR NEW.name li7ke 'Manuel Oliveira' or NEW.name like 'Manoel de Oliveira' THEN
            NEW.name := 'Manoel de Oliveira';
            /* IF EXISTS(Select directorId as ID from dim_directornew where name like 'Manoel de Oliveira') then
                Select directorId as ID from dim_directornew where name like 'Manoel de Oliveira';
                Update FACT_exhibitionnew
                SET directorId = ID
                WHERE directorId = NEW.directorId;
            end IF; */
        END IF;
        -- Remember who changed the payroll when
        RETURN NEW;
    END;
$dim_director_name$ LANGUAGE plpgsql;