SETOF Aggregation Expression

SETOF { index-set } expression

The SETOF aggregation operator evaluates the expression expression for each member of the index set index-set. The result is the set that is formed by collecting the values returned by the operand expression. The operand can be a tuple expression. For example, the following statements produce a set of tuples of numbers with their squared and cubed values:

proc optmodel;
   put (setof{i in 1..3}<i, i*i, i**3>);

Figure 5.34 shows the displayed output.

Figure 5.34: SETOF Aggregation Expression Output

{<1,1,1>,<2,4,8>,<3,9,27>}