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 vote151 views1 answer
Sql server check whether column has same equal values
SQL
0 vote154 views1 answer
Disableforiegn key check
SQL
4 votes152 views1 answer
Oracle error line
SQL
1 vote197 views1 answer
Oracle extract minute from date
SQL
0 vote3.2K views1 answer
PSQL use LIKE with timestamps
SQL
1 vote136 views4 answers
Sql now
SQL
0 vote176 views3 answers
Join
SQL
0 vote161 views1 answer
How to select an index in oracle sql
SQL
0 vote191 views1 answer
Mysql limit order by
SQL
0 vote162 views1 answer
Guid string to binary better
SQL