Re: serie of serie

2020-04-18 Thread Achilleas Mantzios
On 18/4/20 10:18 π.μ., Olivier Leprêtre wrote: Hi, I would like to generate a serie of serie and didn’t find how.  With generate_series. I can generate a serie 1 1 1 2 2 2 3 3 3 But how can I repeat this serie several times ? 1 1 1 2 2 2 3 3 3 1 with foo as (select flo

Re: serie of serie

2020-04-18 Thread Rory Campbell-Lange
On 18/04/20, Olivier Leprêtre (o.lepre...@gmail.com) wrote: > I would like to generate a serie of serie and didn’t find how. With > generate_series. I can generate a serie ... > But how can I repeat this serie several times ? Something like this? gotest=> select a, b from generate_series(1, 3) a