【Postgresql】件数を元に連番を生成する generate_series

luna=# select * from sample;

 stake_no | cnt 

----------+-----

 0001     |   1

 0002     |   3

(2 rows)

luna=# select * from sample,generate_series(1, 99) as id

where sample.cnt >= id;

 stake_no | cnt | id 

----------+-----+----

 0001     |   1 |  1

 0002     |   3 |  1

 0002     |   3 |  2

 0002     |   3 |  3

(4 rows)

terasoluna=#