MIN operator
The MIN operator creates a property that implements finding the minimum value.
Syntax
MIN expr1, ..., exprN
Description
The MIN operator creates a property whose value is the minimum among the values of the specified operands. The skipping of NULL operands and the determination of the result class follow the extremum. An operator written after the last operand belongs to that operand, not to the result: a comparison of the minimum is written (MIN a, b) > c.
Parameters
-
expr1, ..., exprNExpressions whose values the minimum is selected among. At least one operand must be specified.
Examples
price1 = DATA NUMERIC[10,2] (Book);
price2 = DATA NUMERIC[10,2] (Book);
minPrice (Book b) = MIN price1(b), price2(b);
date = DATA DATE (INTEGER);
minDate (INTEGER i) = MIN date(i), 2001_01_01;