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

 1/*
 2REM
 3REM u08.sql
 4REM
 5REM Suppose that we want to provide all loan customers in the
 6REM Perryridge branch with a $200 savings account.
 7REM (Let the loannumber serve as the accountnumber
 8REM  for the new savings account.)
 9REM
10*/
11
12SELECT current_schema();
13SET search_path to "bank";
14
15INSERT INTO Depositor
16  SELECT branchname, loannumber, customername, 200
17  FROM Borrower
18  WHERE branchname = 'Perryridge';