Guest User

Untitled

a guest
Jan 23rd, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. -- get user data and lock that row
  2. SELECT some_column FROM users WHERE id = 2 FOR UPDATE INTO my_var;
  3.  
  4. -- just lock another rows
  5. SELECT some_column FROM users WHERE id IN(4,7) FOR UPDATE;
  6.  
  7. WITH t AS(
  8. UPDATE users
  9. SET some_column = some_column
  10. WHERE id IN(2,4,7)
  11. returning some_column
  12. )
  13. SELECT some_column FROM t WHERE id = 2
  14. INTO my_var;
Add Comment
Please, Sign In to add comment