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 vote310 views2 answers
Mysql output csv
SQL
8 votes363 views3 answers
Postgres database sizes
SQL
1 vote327 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote334 views2 answers
Pad zero sql server
SQL
2 votes383 views1 answer
Remove foreign key constraints in postgres
SQL
2 votes319 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote325 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote326 views1 answer
How to drop a trigger in postgresql
SQL
2 votes335 views3 answers
Sql interview query questions
SQL
0 vote331 views3 answers
Sql delete all except
SQL