sql - How to aggregate two PostgreSQL columns to an array separated by brackets - Stack Overflow

PHOTO EMBED

Fri Apr 29 2022 15:30:52 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira #sql

select id, array_agg(array[x,y])
from the_table
group by id;
content_copyCOPY

https://stackoverflow.com/questions/39212832/how-to-aggregate-two-postgresql-columns-to-an-array-separated-by-brackets