speaking of DO INSTEAD, for insert/update case. Try using RETURNING with that and rules ;) Good luck
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных