Convert Single Value Rows to Array in Postgres

Run Play Copy Copy To

Default Playground

Expand Fork Edit

select array(select id from some.table);