Skip to content

Instantly share code, notes, and snippets.

@khoden
Created September 7, 2017 04:33
Show Gist options
  • Select an option

  • Save khoden/7f04d180c6d05f6f41a0ea9bb89c86c9 to your computer and use it in GitHub Desktop.

Select an option

Save khoden/7f04d180c6d05f6f41a0ea9bb89c86c9 to your computer and use it in GitHub Desktop.
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;
@khoden
Copy link
Copy Markdown
Author

khoden commented Sep 7, 2017

{1,2,3,4,5,6,7,8,9,10}	1
{11,12,13,14,15,16,17,18,19,20}	2
{21,22,23,24,25,26,27,28,29,30}	3
{31,32,33,34,35,36,37,38,39,40}	4
{41,42,43,44,45,46,47,48,49,50}	5
{51,52,53,54,55,56,57,58,59,60}	6
{61,62,63,64,65,66,67,68,69,70}	7
{71,72,73,74,75,76,77,78,79,80}	8
{81,82,83,84,85,86,87,88,89,90}	9
{91,92,93,94,95,96,97,98,99,100}	10

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment