Skip to main content
Version: 7.0

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, ..., exprN

    Expressions 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;