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 vote277 views2 answers
Logical operators in sql
SQL
0 vote275 views1 answer
Find invalid datetime field
SQL
0 vote278 views1 answer
Sql server union if table exist
SQL
1 vote276 views1 answer
Oracle create_program
SQL
0 vote286 views1 answer
Sql developer connect to sql server
SQL
0 vote264 views1 answer
Back up stored procedures mysql
SQL
1 vote280 views1 answer
Select last row from SQL Table
SQL
1 vote265 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote266 views1 answer
Mod function example
SQL
0 vote273 views1 answer
Oracle search columns in schema
SQL