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