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 vote278 views1 answer
How to change null display in psql
SQL
0 vote260 views1 answer
Xampp mysql version
SQL
0 vote286 views1 answer
Sql drop procedure if exists
SQL
0 vote251 views1 answer
Full syntax inner join
SQL
0 vote325 views3 answers
Postgres trim string
SQL
0 vote319 views1 answer
How to use sqlcommand
SQL
0 vote280 views1 answer
Mysql query to check record exists in database table or not
SQL
2 votes249 views3 answers
Mysql cheat sheet
SQL
5 votes269 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote272 views1 answer
Mysql changer nom table
SQL