To specify a literal value for an unnamed ROW type, introduce the literal row with the ROW constructor; you must enclose the values between parentheses. For example, suppose that you define the rectangles table as follows:
CREATE TABLE rectangles ( area FLOAT, rect ROW(x INTEGER, y INTEGER, length FLOAT, width FLOAT), )
The following INSERT statement inserts values into the rect column of the rectangles table:
INSERT INTO rectangles (rect) VALUES ("ROW(7, 3, 6.0, 2.0)")Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]