Yurttas/PL/DBL/postgres/F/01/Bank/u06.sql

 1/*
 2REM
 3REM u06.sql
 4REM
 5REM Accounts with balances
 6REM over $10,000 receive 6 percent interest,
 7REM while all others receive 5 percent.
 8REM
 9*/
10
11SELECT current_schema();
12SET search_path to "bank";
13
14UPDATE Depositor
15SET balance = balance*1.06
16WHERE balance>10000;
17
18UPDATE Depositor
19SET balance = balance*1.05
20WHERE balance<=10000;