PostgreSQL array_agg order Use an ORDER BY, like this example from the manual: SELECT array_agg(a ORDER BY b DESC) FROM table;