Postgresql transaction

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

1 vote213 views1 answer
Restart identity postgresql
SQL
0 vote250 views1 answer
RowDataPacket
SQL
1 vote266 views1 answer
Cannot drop database because it is currently in use
SQL
3 votes276 views1 answer
Sql print all names that start with a given letter
SQL
4 votes262 views1 answer
Id increment ms sql server
SQL
1 vote250 views1 answer
Show table status command in mysql
SQL
0 vote274 views1 answer
Get initials name in sql
SQL
1 vote248 views1 answer
Search for tables with name postgresql
SQL
0 vote256 views1 answer
Oracle free up space in tablespace
SQL
0 vote256 views1 answer
Call procedure in wordpress
SQL