Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- drop table if exists s_multi_update_same_row;
- create table s_multi_update_same_row(
- id int,
- count int
- );
- insert into s_multi_update_same_row select id, 0 from generate_series(1, 1000) as id;
- update s_multi_update_same_row A set count = count + 1 from generate_series(1, 10000) as B(id) where A.id = B.id % 1000 + 1;
- select id, count from s_multi_update_same_row limit 10;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement