2 ms·
how about: UPDATE place SET rating = new.rating from (values (1,25),(2,94),(3,16)) new(id,rating) where place.id = new.id;
by xdanger 8y ago
how about:
UPDATE place
SET rating = new.rating
from (values (1,25),(2,94),(3,16)) new(id,rating)
where place.id = new.id;