Postgresql transaction

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

1 vote181 views2 answers
Get date from datetime postgresql
SQL
0 vote188 views1 answer
Mysql group rows with same value
SQL
10 votes207 views2 answers
Sql rtrim
SQL
0 vote216 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote224 views1 answer
Supprimer les valeur d'une table mysql
SQL
1 vote224 views1 answer
Oracle compile schema
SQL
0 vote205 views1 answer
Python connect microsoft sql server
SQL
0 vote210 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote245 views1 answer
Renommer schema sql
SQL
8 votes201 views3 answers
Mysql alter table add index
SQL