Subquery must return only one column error?

Question

PostgreSQL

Throws subquery must return only one column error.
I want to output an array. What's wrong here?

Answer 1

So what is not clear in the text of the error?
do you see subquery in your query? How many columns are in its result? Well, obviously more than one, otherwise this subquery would not be needed at all.