zaidysf

update workgroups
set name = workgroups.name || ' (' || d.rnk::text || ')'
from (select id, row_number() over (partition by name order by updater_txn_id, id) as rnk from workgroups) d
where workgroups.id = d.id and d.rnk > 1