Minimum

Syntax

MIN(…expr1…, …expr2…, …)

Typing

t1, t2, … -> largest(t1, t2, …)

Description

Return the minimum value of all the operands.

All operands must have compatible types (ie. it is possible to convert one into another).

The result will be NULL if any of the operands is.

Examples

expression evaluates to
MIN(1, 2, 3) 1
MIN("foo", "bar") "bar"
MIN([5; 6], [3; 9]) [3; 9]

See Also

Minimum (aggregate) Maximum