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 vote130 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
3 votes116 views4 answers
Truncate syntax in sql
SQL
0 vote119 views1 answer
Sql server concat null
SQL
0 vote115 views1 answer
Sql server set complex constraints
SQL
3 votes110 views1 answer
Sql multiple column index
SQL
0 vote109 views1 answer
Get sum sqlite android
SQL
0 vote206 views1 answer
Oracle sql alter view add column
SQL
4 votes112 views3 answers
Create database in mySQL
SQL
2 votes135 views1 answer
Grant revoke privileges to mysql username
SQL
1 vote110 views1 answer
Oracle rolling back transactions
SQL