Обсуждение: return an array as aggregate result?

Поиск
Список
Период
Сортировка

return an array as aggregate result?

От
"K. Ari Krupnikov"
Дата:
is there an aggregate function in postgres that returns an array?

something like

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

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