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 vote135 views1 answer
Oracle list constraints
SQL
6 votes156 views6 answers
Rename column postgres
SQL
0 vote160 views1 answer
Primary key start from number
SQL
1 vote129 views1 answer
Pv mysql import
SQL
1 vote182 views1 answer
Mysql is odd
SQL
0 vote163 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote136 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote130 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
1 vote179 views1 answer
Add time to date sql
SQL
1 vote134 views1 answer
Sql string function update replace
SQL