CREATE OR REPLACE FUNCTION public.fn_admin_list_course_admins(p_course_id integer)
 RETURNS TABLE(id integer, professor_id integer, name text, surname text, email text, assigned_at timestamp with time zone)
 LANGUAGE sql
 STABLE
AS $function$
  SELECT ca.id, ca.professor_id, p.name, p.surname, p.email, ca.assigned_at
  FROM public.course_admins ca
  JOIN public.partners p ON p.partner_id = ca.professor_id
  WHERE ca.course_id = p_course_id
  ORDER BY p.surname, p.name;
$function$
;