nums_not_sorted.sql

SELECT remainder, array_agg(i)
FROM (
  SELECT i % 2 AS remainder, i
  FROM generate_series(1, 10) AS i
  ORDER BY i
) nums 
GROUP BY remainder;

heap=# SELECT remainder, array_agg(i)
FROM (
  SELECT i % 2 AS remainder, i
  FROM generate_series(1, 10) AS i
  ORDER BY i
) nums
GROUP BY remainder;
 remainder |  array_agg
-----------+--------------
         0 | {10,2,4,6,8}
         1 | {9,7,3,1,5}
(2 rows)

heap=# SELECT remainder, array_agg(i)
FROM (
  SELECT i % 2 AS remainder, i
  FROM generate_series(1, 10) AS i
  ORDER BY remainder, i
) nums
GROUP BY remainder;
 remainder |  array_agg
-----------+--------------
         0 | {2,4,6,8,10}
         1 | {1,3,5,7,9}
(2 rows)