-- -- notification_request__delete_all_for_user/1 -- create or replace function notification_request__delete_all_for_user( integer ) returns int4 as $$ declare p_user_id alias for $1; v_request RECORD; begin for v_request in select request_id from notification_requests where user_id= p_user_id loop perform notification_request__delete(v_request.request_id); end loop; return 0; end; $$ language plpgsql;