Dbms transaction (psql)

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 vote183 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote186 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
1 vote2.7K views1 answer
Dropping a constraint in ms sql
SQL
0 vote187 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote190 views1 answer
Flexible search query delete table
SQL
3 votes181 views2 answers
Mysql create timestamp column
SQL
1 vote176 views1 answer
Sql select all from one table and one column from another
SQL
15 votes386 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote199 views1 answer
Mysql custom sort order
SQL
5 votes183 views1 answer
Oracle ORA-00054 origin
SQL