Array custom expression

Is there a way with an aggregation (with or without a custom expression) to get just the list of the aggregate results?

Similarly to what you'd do in Postgresql with array_agg.