Yurttas/PL/DBL/postgres/F/01/SPJ/q08.sql

 1/*
 2REM
 3REM q08.sql
 4REM
 5REM Change the color of part 'P02' to 'Yellow',
 6REM increase its weight by 5, and
 7REM set its city to unknown('NULL').
 8REM
 9*/
10
11SELECT current_schema();
12SET search_path to "spj";
13
14UPDATE Parts
15SET color='Yellow',
16    weight=weight+5,
17    city='NULL'
18WHERE pn = 'P02';