Untitled

CREATE OR REPLACE FUNCTION mdm.codelco_average_time_each_step(organization integer DEFAULT NULL::integer, creation_user uuid DEFAULT NULL::uuid)
 RETURNS SETOF mdm.codelco_step_log
 LANGUAGE plpgsql
AS $function$
	declare query text := '';
begin
	IF organization IS NOT NULL then		
		query := 'select  CAST((DATE_PART(''day'', end_action::timestamp - action_date::timestamp) * 24 +  DATE_PART(''hour'', end_action::timestamp - action_date::timestamp)) as int4) as id,  workflow_id, material_creation_id, action_id ,action_date ,end_action ,user_id , before_step , actual_step ,rejection_reason_id ,comment  
			from mdm.codelco_step_log csl inner join mdm.codelco_material_creation cmc on cmc.id = csl.material_creation_id
			where action_id  = 26 and organization_division_id = ' ||  organization || ' order by actual_step ';
	ELSE
		query := 'select  CAST((DATE_PART(''day'', end_action::timestamp - action_date::timestamp) * 24 +  DATE_PART(''hour'', end_action::timestamp - action_date::timestamp)) as int4) as id,  workflow_id, material_creation_id, action_id ,action_date ,end_action ,user_id , before_step , actual_step ,rejection_reason_id ,comment  
			from mdm.codelco_step_log csl inner join mdm.codelco_material_creation cmc on cmc.id = csl.material_creation_id
			where action_id  = 26 order by actual_step ';
	END IF; 
RETURN QUERY EXECUTE query;
END;
$function$