Functions / Conditional Expressions

LEAST

The GREATEST and LEAST functions select the largest or smallest value from a list of any number of expressions.

Reading PG 18current·documented in 22 of 27 versions, 8.1 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

LEAST(value [, ...])

The GREATEST and LEAST functions select the largest or smallest value from a list of any number of expressions. The expressions must all be convertible to a common data type, which will be the type of the result (see Section 10.5 for details).

Version history 3

15 → 16 changed
12 → 13 changed
8.0 → 8.1 added

Definition snapshot: b7bd9cda · English manual source