v.23.7New Feature
Add array_agg as alias for groupArray to enhance PostgreSQL compatibility
Addarray_aggas alias ofgroupArrayfor PostgreSQL compatibility. Closes #52100. ### Documentation entry for user-facing changes. #52135 (flynn).
Why it matters
To provide compatibility with PostgreSQL syntax by allowing users to usearray_agg in ClickHouse queries, which functions identically to groupArray. This eases migration and query portability between PostgreSQL and ClickHouse.How to use it
Simply use the functionarray_agg in your SQL queries as you would use groupArray. For example:SELECT key, array_agg(value) FROM table GROUP BY key;