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 vote340 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
2 votes308 views1 answer
Plsql left() function
SQL
0 vote358 views1 answer
Oracle current date minus 1 day
SQL
0 vote329 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote363 views1 answer
Sql create and grant user access to database
SQL
0 vote309 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote345 views1 answer
T-SQL Create Trigger
SQL
1 vote315 views1 answer
Increase date by one day in sql oracle
SQL
1 vote335 views1 answer
Select tables with name like mysql
SQL
4 votes331 views1 answer
Mysql timestamp in laravel migration
SQL