Extremum (MAX, MIN)
The extremum operator creates a property which calculates the maximum or minimum between several specified properties. If the value of any of these properties is NULL
, this property is ignored. If the values of all properties are NULL
, the result value is also NULL
.
Language
The maximum property is created using the MAX
operator, the minimum - using the MIN
operator.
Examples
date1 = DATA DATE(INTEGER);
date2 = DATA DATE(INTEGER);
maxDate (INTEGER i) = MAX date1(i), date2(i);
balance = DATA INTEGER (Item);
outcome 'Balance (non-negative)' (Item i) = MAX balance(i), 0;
minPrice(Book b) = MIN price1(b), price2(b);
date (INTEGER i) = DATA DATE (INTEGER);
minDate (INTEGER i) = MIN date(i), 2001_01_01;