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>