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 vote111 views1 answer
Change table to innodb mysql
SQL
1 vote135 views1 answer
How not to sort by average rating
SQL
0 vote100 views1 answer
Postgresql like
SQL
4 votes114 views2 answers
Mysql alter table set column unique
SQL
0 vote102 views1 answer
Oracle job schedules
SQL
0 vote117 views1 answer
Sql describe
SQL
16 votes97 views4 answers
Sort by sql
SQL
49 votes190 views6 answers
Mysql add column to table
SQL
0 vote108 views1 answer
Database traccar
SQL
4 votes171 views1 answer
What are the data types
SQL