Stored Procedure
DROP TABLE IF EXISTS user_response; create or replace procedure all_pending_status () language plpgsql as $$ declare assignments integer []; assignment integer ; begin select array_agg (action_assignments. id ) into assignments from action_assignments where active = true ; FOREACH assignment in ARRAY assignments LOOP call get_pending_status ( assignment , CURRENT_DATE ); end loop ; end ; $$ ; create or replace procedure get_pending_status ( action_assignment int , due_date_target date ) language plpgsql as $$ declare overdue_count integer ; recent_event_id integer ; responsible_users integer []; user_id int ; result record ; not_started_user varchar ; action_assignment_record record ; begin create table if not exists user_response ( id SERIAL PRIMARY KEY , name varchar , user_id int , response varchar , action_response_id int , ac...