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

3 votes126 views1 answer
Two select sql
SQL
0 vote122 views1 answer
Plpgsql if statement
SQL
0 vote129 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote119 views1 answer
Get yesterday date ISO in psql
SQL
0 vote137 views3 answers
Run sql command line
SQL
0 vote137 views2 answers
How to get max from each department in sql
SQL
0 vote123 views2 answers
Oracle create chain rule
SQL
0 vote133 views1 answer
Mysql random number between 1 and 100
SQL
2 votes87 views1 answer
Foreign key example in dbms
SQL
7 votes130 views2 answers
Execute mysql file
SQL