Dbms transaction (psql)

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

34 votes282 views5 answers
Oracle alter table add column
SQL
0 vote283 views1 answer
Vbscript connect mssql
SQL
1 vote257 views1 answer
Select inside insert query
SQL
23 votes259 views6 answers
Delete all rows from table sql
SQL
-1 vote282 views2 answers
Sql truncate number
SQL
0 vote262 views1 answer
St_buffer mysql
SQL
0 vote267 views1 answer
Select even number id data from table
SQL
0 vote254 views1 answer
Min and max salary and name in sql
SQL
2 votes257 views1 answer
Apex date today add days
SQL
0 vote270 views1 answer
Postgresql cast as year and month from timestamp
SQL