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.
This exercise is part of the course
Transactions and Error Handling in PostgreSQL
Exercise instructions
BEGIN
the transaction.- Update the
RCONP752
field to be'true'
whereRCON2365
is bigger than $5,000,000. - Close out the transaction with
COMMIT
. - Select the count of rows where
RCONP752
is'true'
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Begin a new transaction
___;
-- Update RCOP752 to true if RCON2365 is over 5000000
UPDATE ffiec_reci
___ RCONP752 = 'true'
WHERE RCON2365 > ___;
-- Commit the transaction
___;
-- Select a count of records now true
SELECT COUNT(RCONP752)
FROM ffiec_reci
WHERE ___ = 'true';