1. Learn
    2. /
  2. Courses
    3. /
  3. Transactions and Error Handling in PostgreSQL

Exercise

Multistatement Rollbacks

Now let's use multiple statements in a transaction to set a flag in FIELD48 based on if it holds US state government assets represented in RCON2203, foreign assets represented in RCON2236, or both. The values for FIELD48 should be 'US-STATE-GOV', 'FOREIGN', or 'BOTH' respectively. However, You've made a mistake in the statement for both.

Instructions

100 XP
  • Build 3 update statements to detect each condition and set the flag.
  • Undo the mistake of setting it to 'BOOTH' instead of 'BOTH' by rolling back the transaction.
  • Select a count of records where the flag is set to 'BOOTH'.