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 vote225 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote221 views1 answer
Casterar postgres
SQL
2 votes267 views1 answer
Oracle run_duration to number
SQL
0 vote207 views1 answer
Heavy table in mysql
SQL
12 votes216 views1 answer
How to change the value of a table in sql
SQL
3 votes244 views2 answers
To_char sql
SQL
8 votes230 views1 answer
Oracle current date plus 1 month
SQL
0 vote247 views2 answers
Mysql dump database tables only
SQL
1 vote250 views1 answer
Opensuse restart MySQL
SQL
0 vote243 views1 answer
Bidirectional outer join sql
SQL