Postgres Pro
Downloads
Home   >   mailing lists

Thread: Concatenate results of a single column query

Concatenate results of a single column query

From
Marco Lazzeri
Date:
Hi All,
I would like to concatenate results of a single column query, something
like the futurable (dev docs for 7.5)

SELECT p.name, ARRAY(SELECT nicknames FROM people WHERE people.id = p.id)
FROM people AS p

Any suggestions?

Thanks
Marco