PLPGSQL | integer |
declare p_seq_id alias for $1; p_new_set_id alias for $2; begin -- ---- -- Grab the central configuration lock -- ---- lock table sl_config_lock; -- ---- -- Move the sequence to the new set -- ---- update sl_sequence set seq_set = p_new_set_id where seq_id = p_seq_id; return p_seq_id; end; |