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

3 votes311 views1 answer
Sql add two values together
SQL
1 vote279 views1 answer
Mysql show data from table
SQL
1 vote300 views3 answers
Java.sql.sqlexception: access denied for user
SQL
6 votes338 views6 answers
Rename column postgres
SQL
0 vote291 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote343 views3 answers
Mysql CAST(amount as float)
SQL
0 vote283 views2 answers
Sql update top 100
SQL
4 votes296 views1 answer
Create db table
SQL
0 vote298 views1 answer
Connect to nginx server mysql remotly
SQL
3 votes284 views2 answers
Pl sql escape '
SQL