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

4 votes199 views1 answer
Id increment ms sql server
SQL
0 vote201 views1 answer
Pl/pgsql declare variable
SQL
0 vote211 views1 answer
Insert or update sql firebird
SQL
0 vote187 views1 answer
Oracle index hint
SQL
0 vote191 views1 answer
Count the table indatabase
SQL
0 vote225 views2 answers
Impala rename column name
SQL
1 vote181 views1 answer
Mysql show data from table
SQL
0 vote214 views1 answer
Group by 15 minute interval sql server
SQL
6 votes188 views1 answer
How to count number of rows in sql
SQL
2 votes216 views3 answers
Postgres json to string
SQL