CREATE OR REPLACE FUNCTION public.fn_admin_update_professor_assignment(p_id integer, p_level_id integer DEFAULT NULL::integer)
 RETURNS jsonb
 LANGUAGE plpgsql
AS $function$
BEGIN
    UPDATE public.course_professor_levels
    SET level_id = p_level_id
    WHERE id = p_id;

    IF NOT FOUND THEN
        RETURN jsonb_build_object('error', 'Asignación no encontrada.');
    END IF;

    RETURN jsonb_build_object('success', true);
END;
$function$
;
