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 vote346 views1 answer
Datetime postgres typeorm
SQL
1 vote348 views1 answer
Alphabetical order mysql
SQL
0 vote297 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
2 votes343 views2 answers
Created at and updated at in mysql
SQL
4 votes329 views2 answers
Mysql select where starts with
SQL
1 vote327 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote350 views1 answer
Mysql url data type
SQL
2 votes323 views2 answers
Laravel query builder toSql
SQL
0 vote319 views1 answer
Pl sql search saurce code
SQL
4 votes387 views3 answers
Postgres drop all tables
SQL