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

Exercise

Making our first transaction

Now you're ready to build your first transaction. As mentioned in the slides, you are working with data from the FFEIC, which is the organization in the US that sets bank standards and reporting formats. Recently they changed the rules for reporting if you provide consumer deposit accounts to being true only if you have more than $5,000,000 in brokered deposits.

Let's use a transaction to make that update safely. The "Provides Consumer Deposits" flag is in the RCONP752 column and the brokered deposits is in the RCON2365 column.

Instructions

100 XP
  • BEGIN the transaction.
  • Update the RCONP752 field to be 'true' where RCON2365 is bigger than $5,000,000.
  • Close out the transaction with COMMIT.
  • Select the count of rows where RCONP752 is 'true'.