1.81.  mergeset_int( integer, integer )

Propriétés de la fonction
Langage: PLPGSQL
Type du code retour: integer

Exécute un événement MERGE_SET, assemblant tous les objets de l'ensemble add_id dans l'ensemble set_id.

declare
        p_set_id                        alias for $1;
        p_add_id                        alias for $2;
begin
        -- ----
        -- Grab the central configuration lock
        -- ----
        lock table sl_config_lock;
        
        update sl_sequence
                        set seq_set = p_set_id
                        where seq_set = p_add_id;
        update sl_table
                        set tab_set = p_set_id
                        where tab_set = p_add_id;
        delete from sl_subscribe
                        where sub_set = p_add_id;
        delete from sl_setsync
                        where ssy_setid = p_add_id;
        delete from sl_set
                        where set_id = p_add_id;

        return p_set_id;
end;