Rows that contain unnamed row types
Suppose you create the table that the following figure
shows. The student table defines the s_address column
as an unnamed row type.
The following statement shows you how to add a row to
the student table. To insert into the unnamed row-type column s_address,
use the ROW constructor but do not cast the row-type value.
INSERT INTO student
VALUES ('Keene, Terry',
ROW('53 Terra Villa', 'Wheeling', 'IL', '45052'),
3.75);