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 vote204 views2 answers
Postgresql get difference in hours between two dates
SQL
-1 vote213 views1 answer
Ssql to lowercqse
SQL
0 vote188 views1 answer
Selects all the columns from the sailors table
SQL
0 vote202 views7 answers
Les jointures sql server
SQL
7 votes232 views2 answers
How to create index mysql
SQL
0 vote194 views1 answer
Multiple left join mysql
SQL
2 votes202 views1 answer
Set boolean flasksql
SQL
3 votes208 views2 answers
Postgresql remove not null constraint
SQL
0 vote195 views1 answer
Sql select rows between 1000 and 2000
SQL
1 vote210 views1 answer
Oracle sql average
SQL