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 vote190 views1 answer
Drop table if exists oracle
SQL
0 vote193 views1 answer
Addition of 2 column value in mysql
SQL
3 votes221 views5 answers
No module named 'MySQLdb'
SQL
0 vote186 views1 answer
Azure sql server check foreign key
SQL
0 vote199 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote219 views1 answer
Mysql best varchar length size
SQL
0 vote181 views6 answers
Unique key in sql
SQL
1 vote242 views1 answer
Sql where max date
SQL
0 vote220 views1 answer
Mysql conf.d exampel
SQL
0 vote194 views1 answer
Write sql query to show the details start from digit
SQL