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 vote348 views1 answer
Output table plsql
SQL
6 votes338 views1 answer
How to count number of rows in sql
SQL
0 vote411 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote334 views2 answers
Mysql slave status
SQL
2 votes343 views2 answers
Postgresql date at timezone
SQL
0 vote373 views1 answer
Error code 1241 mysql
SQL
0 vote351 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote340 views1 answer
Order by number of character in sql
SQL
0 vote429 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
1 vote387 views2 answers
Maximum number of tables in mysql
SQL