I would probably do that in plpgsql, as a cursor
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных