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 vote144 views1 answer
Porcentaje sql
SQL
0 vote139 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote140 views4 answers
How to connect form to database
SQL
58 votes336 views4 answers
Mysql drop column
SQL
2 votes142 views5 answers
SQL trigger
SQL
0 vote121 views1 answer
Faire une recherche par liste de mot clé sql
SQL
4 votes137 views3 answers
Postgres set default value
SQL
0 vote137 views1 answer
MySQL error code 2068
SQL
2 votes145 views2 answers
Postgresql search all tables for column name
SQL
0 vote147 views1 answer
Primary key multiple
SQL