Confirme (enregistré dans sl_confirm) que les éléments allant de p_con_origin à p_con_seqno ont été reçus par le nœud p_con_received à p_con_timestamp, et ajoute un événement pour envoyer cette confirmation.

declare
        p_con_origin    alias for $1;
        p_con_received  alias for $2;
        p_con_seqno             alias for $3;
        p_con_timestamp alias for $4;
        v_max_seqno             bigint;
begin
        select into v_max_seqno coalesce(max(con_seqno), 0)
                        from sl_confirm
                        where con_origin = p_con_origin
                        and con_received = p_con_received;
        if v_max_seqno < p_con_seqno then
                insert into sl_confirm 
                                (con_origin, con_received, con_seqno, con_timestamp)
                                values (p_con_origin, p_con_received, p_con_seqno,
                                        p_con_timestamp);
                notify "_schemadoc_Confirm";
                v_max_seqno = p_con_seqno;
        end if;

        return v_max_seqno;
end;