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.
Este exercício faz parte do curso
Transactions and Error Handling in PostgreSQL
Instruções do exercício
- Create a transaction.
- Update
FIELD48toMMDAifRCON6810(MMDA value) is greater than5000000. - Set a savepoint named
mmda_flag_set. - Rollback the whole transaction.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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;