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>}
|