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 vote160 views1 answer
How to compile a function in oracle
SQL
0 vote107 views1 answer
Sql not exists
SQL
0 vote98 views1 answer
Name '_mysql' is not defined
SQL
-1 vote107 views1 answer
Can pandas fetch data from sql
SQL
0 vote102 views1 answer
Sql character index
SQL
3 votes133 views2 answers
How to View column names of a table in SQL
SQL
0 vote115 views1 answer
Mysql 8 geo to json
SQL
2 votes243 views1 answer
Set auto increment from 1
SQL
0 vote107 views1 answer
Implizite joins sql
SQL
0 vote129 views1 answer
Declaring variables in pl sql
SQL