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

2 votes204 views1 answer
Drop table if exists in postgres
SQL
3 votes200 views2 answers
To_char sql
SQL
0 vote206 views1 answer
Oracle character index
SQL
1 vote202 views1 answer
Sql bitwise operators
SQL
0 vote209 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote204 views1 answer
Sql pad left 0
SQL
0 vote198 views1 answer
T-sql update table variale
SQL
10 votes191 views3 answers
Sql limit results
SQL
-1 vote294 views5 answers
Left join
SQL
24 votes203 views4 answers
How to add column sql
SQL