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 vote188 views2 answers
Mysql limit offset
SQL
54 votes285 views6 answers
Sql rename column
SQL
0 vote213 views1 answer
Jpa generationtype sequence mysql
SQL
10 votes170 views4 answers
Sql pagination
SQL
0 vote185 views1 answer
Postgresql auto increment not working
SQL
0 vote171 views1 answer
Sql query to select records entered in last 24 hours
SQL
3 votes181 views2 answers
Mysql create timestamp column
SQL
0 vote169 views1 answer
Mysql money value
SQL
0 vote172 views1 answer
Redudancy in SQL
SQL
1 vote177 views1 answer
Install postgresql on raspberry pi
SQL