postgres alter table并插入行概率

I want to sum the weight of rows with the same id1 and then computes the ratio for each of that row (sort of like a probability) in a column prob.I want to sum the weight of rows with the same