Postgres Pro
Downloads
Home   >   mailing lists

Thread: return an array as aggregate result?

return an array as aggregate result?

From
"K. Ari Krupnikov"
Date:
is there an aggregate function in postgres that returns an array?

something like

SELECT ARRAY (name) FROM TABLE WHERE LAST = 'smith';

      array
------------------
{{"sam"},{"mike"}}