ARRAY_MAX()

All functions > ARRAY > ARRAY_MAX()

Returns the largest value in an array using natural ordering.

Signatures

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

ARRAY_MAX(array: ARRAY<T>) → T

Notes

• Returns the maximum element using natural ordering
• Ignores NULL values when determining the maximum
• 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 maximum
    f1 := ARRAY_MAX(ARRAY(1, 5, 3)),
    -- Lexicographic maximum
    f2 := ARRAY_MAX(ARRAY('apple', 'zebra', 'banana')),
    -- Empty array
    f3 := ARRAY_MAX(ARRAY()::BIGINT[])
;