September 26, 2024: PostgreSQL 17 Released!

Feature Description

unnest/array_agg

unnest allows for arrays to be "unnested" and expanded into a set of rows.

Conversely, array_agg can take the output of a set of rows and aggregate them into an array.

For more information: