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

16 votes157 views3 answers
Update table from another table
SQL
15 votes184 views4 answers
Sql update from select
SQL
7 votes163 views2 answers
N highest salary in sql
SQL
0 vote108 views1 answer
How to fetch highest score in minimum time using mysql
SQL
1 vote179 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote154 views1 answer
PSQL qith variables
SQL
4 votes140 views1 answer
Search column by name mysql
SQL
0 vote156 views1 answer
Reona
SQL
0 vote149 views1 answer
Uncomment listen_address=localhost
SQL
0 vote159 views1 answer
How to display value of variable in mysql
SQL