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

13 votes396 views2 answers
Oracle select into and inner join
SQL
0 vote343 views2 answers
Sql server set default value equal to auto increment
SQL
2 votes360 views2 answers
Sql percentage
SQL
1 vote363 views1 answer
Where date = max(date) in sql
SQL
0 vote342 views1 answer
SqlFunction does not exist
SQL
0 vote344 views1 answer
Import sql dump into postgresql database
SQL
1 vote375 views1 answer
Create new table from old table with data
SQL
0 vote357 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote350 views2 answers
How to combine diff colmun value using group by postgres
SQL
6 votes377 views2 answers
Sql sequence
SQL