You probably want to use a trigger rather than rule for modifications like that. I think someone's put up one on the mailing lists fairly recently (within a couple of months anyway) so you might be able to find it in the archives.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных