Yurttas/PL/DBL/postgres/F/01/PC/q12.sql

 1/*
 2REM
 3REM q12.sql
 4REM
 5REM Delete all PC's with less than 2 gigabyte of hard disk.
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "pc";
11
12DELETE FROM Product
13WHERE model IN (SELECT model
14		FROM PC
15                WHERE hd<2.0);
16
17DELETE FROM PC
18WHERE hd<2.0;