khoden · September 7, 2017 04:33 · khoden · Sep 7, 2017
diff --git a/split_by_chanks.sql b/split_by_chanks.sql
 SELECT
  array_agg(s),
  rn
 FROM (SELECT
        s,
        ((row_number()
        OVER ()) - 1) / 10 + 1 AS rn
      FROM generate_series(1, 100) s) g
 GROUP BY rn
 ORDER BY rn;
	SELECT
	array_agg(s),
	rn
	FROM (SELECT
	s,
	((row_number()
	OVER ()) - 1) / 10 + 1 AS rn
	FROM generate_series(1, 100) s) g
	GROUP BY rn
	ORDER BY rn;
No results found