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

6 votes141 views5 answers
Mysql get last insert id
SQL
-1 vote153 views1 answer
Default username and password for oracle 11g
SQL
6 votes154 views1 answer
Oracle rank
SQL
10 votes134 views4 answers
Primary key in sql
SQL
8 votes149 views2 answers
Alert table name mysql
SQL
12 votes159 views5 answers
Rename table in mysql
SQL
0 vote104 views0 answer
SQL
1 vote135 views1 answer
Local sql server
SQL
23 votes161 views2 answers
Query to delete a database in mysql
SQL
0 vote141 views1 answer
Get week day name sql server
SQL