UPDATE place SET rating = new.rating from (values (1,25),(2,94),(3,16)) new(id,rating) where place.id = new.id;