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 votes211 views3 answers
List columns in table postgres
SQL
2 votes219 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote280 views1 answer
Mysql get longest string in column
SQL
3 votes223 views1 answer
Two select sql
SQL
0 vote219 views1 answer
Select lowest values sql
SQL
4 votes201 views1 answer
Sql group by year
SQL
61 votes332 views6 answers
Mysql add column
SQL
2 votes214 views1 answer
Oracle index size
SQL
1 vote204 views1 answer
How to get alternate records from a table in sql
SQL
0 vote220 views1 answer
Running query in redshift
SQL