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 vote146 views1 answer
Split string by comma in sql server
SQL
0 vote132 views1 answer
Sub blocks in sql
SQL
0 vote158 views1 answer
Mysql change innodb to myisam
SQL
0 vote157 views1 answer
Mysql range of dates overlap
SQL
0 vote160 views1 answer
Tsql table column constraint must be uppercase
SQL
1 vote137 views1 answer
Error code 1055
SQL
5 votes149 views1 answer
Sql check if date is between 2 dates
SQL
0 vote158 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
1 vote158 views1 answer
Sql select whole row max column
SQL
16 votes144 views3 answers
Delete row psql
SQL