Update rows that contain unnamed row types

To update a column that is defined on an unnamed ROW type, you must specify all fields of the ROW type. For example, the following statement updates only the street and city fields of the address column in the student table, but each field of the ROW type must contain a value (NULL values are allowed):

UPDATE student
   SET s_address = ROW('13 Sunset', 'Fresno', 
   s_address.state, s_address.zip)
   WHERE s_name = 'henry, john';