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 vote183 views3 answers
Error: mysql shutdown unexpectedly.
SQL
6 votes164 views2 answers
Difference between join vs union
SQL
-1 vote154 views1 answer
Sql set max value in column
SQL
0 vote168 views1 answer
Selecting all columns from table sql database
SQL
0 vote171 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
10 votes174 views4 answers
Fetch first 5 characters of the string in sql
SQL
7 votes148 views2 answers
Html to react converter
SQL
0 vote145 views1 answer
Mysql change default collation
SQL
0 vote151 views2 answers
Starting mysql service from mac
SQL
5 votes200 views1 answer
Dbms_metadata.get_ddl table
SQL