On 18/04/20, Olivier Leprêtre (o(dot)lepretre(at)gmail(dot)com) wrote:
> I would like to generate a serie of serie and didnt 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) as t(a), generate_series(1, 3) as u(b);
a | b
---+---
1 | 1
1 | 2
1 | 3
2 | 1
2 | 2
2 | 3
3 | 1
3 | 2