RES: help with generation_series in pg10

2018-01-10 Thread Márcio A . Sepp
> >> > how can i have the same in pg10 as i have had in pg 9.x? > >> > >> Move the function call to the FROM clause: > >> > >> select g, (g - 1) % 5 + 1 from generate_series(1, 10) g; > > > > thank you. That is exact what i need. > > > > > >> > I need it to date type to... if possible. > >> > >> T

Re: help with generation_series in pg10

2018-01-10 Thread Merlin Moncure
On Tue, Jan 9, 2018 at 10:14 AM, Márcio A. Sepp wrote: > >> > how can i have the same in pg10 as i have had in pg 9.x? >> >> Move the function call to the FROM clause: >> >> select g, (g - 1) % 5 + 1 from generate_series(1, 10) g; > > thank you. That is exact what i need. > > >> > I need it to dat

Re: help with generation_series in pg10

2018-01-10 Thread Merlin Moncure
On Mon, Jan 8, 2018 at 11:19 PM, Adrian Klaver wrote: > On 01/08/2018 05:25 PM, Márcio A. Sepp wrote: >> >> >> Hi, >> >> >> In pg10 generation series doesn't work like in 9.5. >> Ex. in 9.5: >> z=# select generate_series(1, 10), generate_series(1, 5); >> generate_series | generate_series >>

Re: RES: help with generation_series in pg10

2018-01-09 Thread Alvaro Herrera
Márcio A. Sepp wrote: > > There is a generate_series() variant that can return dates (more > > precisely, timestamp with time zone). But what exactly would you like > > returned? > > In the past i use querys like this to generate some timestamp field: > select generate_series (1, 10), generate_s

RES: help with generation_series in pg10

2018-01-09 Thread Márcio A . Sepp
> > how can i have the same in pg10 as i have had in pg 9.x? > > Move the function call to the FROM clause: > > select g, (g - 1) % 5 + 1 from generate_series(1, 10) g; thank you. That is exact what i need. > > I need it to date type to... if possible. > > There is a generate_series() vari

Re: help with generation_series in pg10

2018-01-09 Thread Vincenzo Romano
2018-01-09 11:01 GMT+01:00 Alvaro Herrera : > Márcio A. Sepp wrote: > >> how can i have the same in pg10 as i have had in pg 9.x? > > Move the function call to the FROM clause: > > select g, (g - 1) % 5 + 1 from generate_series(1, 10) g; > >> I need it to date type to... if possible. > > There is

Re: help with generation_series in pg10

2018-01-09 Thread Alvaro Herrera
Márcio A. Sepp wrote: > how can i have the same in pg10 as i have had in pg 9.x? Move the function call to the FROM clause: select g, (g - 1) % 5 + 1 from generate_series(1, 10) g; > I need it to date type to... if possible. There is a generate_series() variant that can return dates (more

Re: help with generation_series in pg10

2018-01-08 Thread David G. Johnston
On Monday, January 8, 2018, Adrian Klaver wrote: > > I am not seeing a solution, but you might see something that would help > you. There is no general solution. For the problem at hand I would union two generate_series(1,5) queries with a query_id column. Then I'd use row_number() over (orde

Re: help with generation_series in pg10

2018-01-08 Thread Adrian Klaver
On 01/08/2018 05:25 PM, Márcio A. Sepp wrote: Hi, In pg10 generation series doesn't work like in 9.5. Ex. in 9.5: z=# select generate_series(1, 10), generate_series(1, 5); generate_series | generate_series -+- 1 | 1

help with generation_series in pg10

2018-01-08 Thread Márcio A . Sepp
Hi, In pg10 generation series doesn't work like in 9.5. Ex. in 9.5: z=# select generate_series(1, 10), generate_series(1, 5); generate_series | generate_series -+- 1 | 1 2 | 2 3 |