UPDATE users u
SET
score = v.new_score,
status = v.new_status,
rank = v.new_rank
FROM (
VALUES
(1, 100, 'active', 5),
(3, 85, 'inactive', 7),
(5, 120, 'pending', 3)
) AS v(id, new_score, new_status, new_rank)
WHERE u.id = v.id
RETURNING *
UPDATE users u
SET
score = v.new_score,
status = v.new_status,
rank = v.new_rank
FROM (
VALUES
(1, 100, 'active', 5),
(3, 85, 'inactive', 7),
(5, 120, 'pending', 3)
) AS v(id, new_score, new_status, new_rank)
WHERE u.id = v.id
RETURNING *
