ARRAY_MIN()

All functions > ARRAY > ARRAY_MIN()

Returns the smallest value in an array using natural ordering.

Signatures

Returns: The smallest value in the array, or NULL for empty arrays

ARRAY_MIN(array: ARRAY<T>) → T

Notes

• Returns the minimum element using natural ordering
• Ignores NULL values when determining the minimum
• Returns NULL if array is empty or contains only NULL values
• Works with numbers, strings, dates, or any comparable type
• Uses lexicographic ordering for strings
• Supports ARRAY<ROW> and ARRAY<ARRAY<T>>: ordering is lexicographic over field values / sub-array elements

See also

• Array functions

Examples

SELECT
    -- Numeric minimum
    f1 := ARRAY_MIN(ARRAY(1, 5, 3)),
    -- Lexicographic minimum
    f2 := ARRAY_MIN(ARRAY('apple', 'zebra', 'banana')),
    -- Empty array
    f3 := ARRAY_MIN(ARRAY()::BIGINT[])
;