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

5 votes257 views2 answers
Copy data from one database to another
SQL
0 vote272 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote260 views1 answer
Using distinct and count together in sql
SQL
5 votes284 views1 answer
How to get all table names in sql query
SQL
0 vote266 views1 answer
Mysql readable output
SQL
6 votes259 views3 answers
Mysql change auto_increment start value
SQL
5 votes267 views1 answer
Sqlite alter table add column
SQL
0 vote291 views1 answer
Drop view in mysql
SQL
0 vote262 views1 answer
How to get data between a last week in mysql
SQL
1 vote227 views2 answers
Get date from datetime postgresql
SQL