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 vote354 views1 answer
Mysql remove last character
SQL
0 vote289 views1 answer
How to set field to null in sql
SQL
1 vote361 views1 answer
Altrer name column postgres
SQL
10 votes331 views3 answers
Sql check double value
SQL
0 vote316 views1 answer
How to change mysql port in xampp
SQL
1 vote353 views1 answer
Sql drop schema
SQL
-2 votes329 views1 answer
Remove root password mysql
SQL
2 votes344 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote321 views1 answer
Can we rollback deleted data in sql
SQL
2 votes350 views3 answers
Sql server: how to concatenate column data using comma
SQL