return an array as aggregate result? - Mailing list pgsql-general

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

something like

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

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