Re: serie of serie

Sat, 18 Apr 2020 02:00:24 -0700 

On 18/04/20, Olivier Leprêtre ([email protected]) 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) 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

Reply via email to