给linkid重新赋值,新的id按序列递增
update temp_tbl as c
set link_id=(186781+b.new_id)
from
(
select * from
(
select
row_number() over(order by link_id) as new_id, link_id,
generate_series(1, 100) as seq
from temp_tbl
) as a
where a.new_id = a.seq
) as b
where b.link_id=c.link_id
|