return an array as aggregate result?

Started by K. Ari Krupnikovover 24 years ago1 messagesgeneral
Jump to latest
#1K. Ari Krupnikov
ari@cogsci.ed.ac.uk

is there an aggregate function in postgres that returns an array?

something like

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

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