SELECT * FROM foo CROSS JOIN LATERAL generate_series(1,number);
merlin .
Hi Merlin, I've tried your suggested code and with cross join and generate_series I can generate multiple row. There is a way to put as second args a column values? I've tried to put "table.number" column values but I got "generate_series() does not exists". Inserting a simple int like 5 I get 5 results for each row.
I've searched on google but can't find a valid example.
Thanks in advance.
Hi Merlin, I've solved my problem (passing column as number) using a cast generate_series(1,table.number::int)