Dynamic Server supports expressions that are literal representations of the values of built-in or user-defined collection data types. The following examples show literal collections as expressions:
INSERT INTO tab_a (set_col) VALUES ("SET{6, 9, 3, 12, 4}")
INSERT INTO TABLE(a_set) VALUES (9765)
UPDATE table1 SET set_col = "LIST{3}"
SELECT set_col FROM table1
WHERE SET{17} IN (set_col)
For more information, see Literal Collection. For the syntax of element values, see Collection Constructors.
A constructor is a function that the database server uses to create an instance of a specific data type. The database server supports ROW constructors and collection constructors.
Constructor Expressions: .-,-------------------. V (1) | |--+-ROW--(----| Expression |------+--)-+-----------------------| | (2) | '-| Collection Constructors |--------'