Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH user_info AS (
- SELECT user_id FROM hello_schema.users
- WHERE user_id = uuid($1)
- ),
- balance_info AS (
- UPDATE hello_schema.user_balance
- SET balance = balance + $2
- WHERE user_id = (SELECT user_id FROM user_info) AND ($2 >= 0 OR balance > abs($2))
- RETURNING balance
- )
- SELECT (SELECT user_id FROM user_info), (SELECT balance FROM balance_info);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement