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

0 vote191 views1 answer
Oracle simple quote
SQL
0 vote182 views1 answer
T-sql update table variale
SQL
2 votes230 views1 answer
Sql string starts with
SQL
0 vote177 views1 answer
Mql5 list all available symbols
SQL
0 vote200 views1 answer
Sql out file formate
SQL
0 vote184 views1 answer
Run postgresql dump to csv
SQL
0 vote244 views1 answer
Sql select rows between 1000 and 2000
SQL
38 votes252 views6 answers
Alter table mysql
SQL
0 vote216 views3 answers
Sql select statements
SQL
-3 votes174 views1 answer
Remove spaces sql 2008
SQL