Dbms transaction (psql)

BEGIN;
UPDATE accounts SET balance = balance - 100.00
    WHERE name = 'Alice';
SAVEPOINT my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Bob';
-- oops ... forget that and use Wally's account
ROLLBACK TO my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Wally';
COMMIT;

Source: postgresql.org

Similar codes

0 vote374 views2 answers
How to get max from each department in sql
SQL
0 vote361 views3 answers
Mysql regex replace
SQL
1 vote334 views1 answer
Ef core 5.0 usesqlserver not found
SQL
32 votes357 views6 answers
Sql count where
SQL
0 vote397 views1 answer
Get initial in sql
SQL
0 vote330 views3 answers
Group_concat sql server
SQL
3 votes425 views4 answers
Sql interview questions
SQL
2 votes356 views1 answer
How to get non distinct values in sql
SQL
0 vote394 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote347 views2 answers
Sql server concat string and int
SQL