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 vote221 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote207 views1 answer
Big table in mysql
SQL
9 votes195 views3 answers
Mysql show table column full description
SQL
0 vote261 views1 answer
Sql decimal to 2 places
SQL
0 vote209 views1 answer
Select year from dual oracle
SQL
0 vote235 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote321 views1 answer
How to update random rows in sql
SQL
1 vote190 views1 answer
How to find median of a column sql
SQL
0 vote198 views1 answer
Java check if something is in mysql table
SQL
1 vote197 views1 answer
Sometimes i cant edit sql developer
SQL