postgres array_agg function

Postgres has a flexible and robust array datatype that comes with a variety of functions, including array_agg, which gathers values into an array.  See this blogpost by Craig Kerstiens.