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

39 votes383 views5 answers
Sql drop column
SQL
3 votes330 views2 answers
Mysql user permission database
SQL
0 vote312 views1 answer
Month mysql
SQL
0 vote339 views1 answer
Typeorm raw sql
SQL
0 vote329 views1 answer
Null column as zero in mysql
SQL
4 votes328 views4 answers
Pl sql output
SQL
0 vote337 views1 answer
No query unable to fetch row sqlite
SQL
0 vote329 views1 answer
Create a table from one field of another table
SQL
5 votes298 views2 answers
Oracle to_timestamp
SQL
0 vote346 views1 answer
Oarcale list objects
SQL