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 vote294 views3 answers
Execute sp in sql server
SQL
0 vote280 views1 answer
Postgresql create user roles
SQL
16 votes274 views1 answer
CTE statement sql server
SQL
0 vote280 views1 answer
Sql server cannot create database diagram
SQL
0 vote318 views1 answer
Show all sequences postgres
SQL
-1 vote293 views2 answers
Postgresql user permissions to database
SQL
0 vote295 views1 answer
Sqlite explain plan
SQL
0 vote303 views1 answer
Mysql best varchar length size
SQL
0 vote275 views1 answer
Power bi dax add related shows column but not working
SQL
4 votes276 views1 answer
Restart for pg_hba.conf file
SQL