Re: serie of serie

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 floor(a) as a from
generate_series(1.33333333333333333333,4,1.0/3.0) as s(a))
select foo.a from foo, generate_series(1,10) as itera(b) order by b,a;

> 1
>
> 1
>
> 2
>
> 2
>
> 2
>
> 3
>
> 3
>
> 3
>
> 1
>
> 1
>
> 1
>
> 2
>
> 2
>
> 2
>
> 3
>
> 3
>
> 3
>
> Thanks for any help,
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
> Garanti sans virus. www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
>
>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>