Skip to content

ARRAY_COMPACT

ARRAY_COMPACT(arr)

Returns a compacted array with missing and null values removed from arr, effectively converting sparse arrays into dense arrays. Return NULL when arr is NULL.