Working with a single savepoint
Banks that carry large value in Money Market Deposit Accounts (MMDA) are often resilient to downturns in the economy. In order to classify banks, we'll use a flag field such as FIELD48 to store information useful for further processing. Let's flag banks with over 5000000.
Cet exercice fait partie du cours
Transactions and Error Handling in PostgreSQL
Instructions
- Create a transaction.
- Update
FIELD48toMMDAifRCON6810(MMDA value) is greater than5000000. - Set a savepoint named
mmda_flag_set. - Rollback the whole transaction.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
BEGIN;
-- Set the flag to indicate that they hold MMDAs where more than $5 million
UPDATE ffiec_reci
SET FIELD48 = '___'
WHERE ___ > 5000000;
-- Set a savepoint
___ ___;
-- Rollback the whole transaction
___;
COMMIT;