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.

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;