help with generation_series in pg10

From: Márcio A(dot) Sepp <marcio(at)zyontecnologia(dot)com(dot)br>
To: "'pgsql-general'" <pgsql-general(at)postgresql(dot)org>
Subject: help with generation_series in pg10
Date: 2018-01-09 01:25:51
Message-ID: 00bb01d388e8$c9607b50$5c2171f0$@com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 | 3
4 | 4
5 | 5
6 | 1
7 | 2
8 | 3
9 | 4
10 | 5
(10 registros)

so, in version 10 the same sql show different result set.
z=# select generate_series(1, 10), generate_series(1,5);
generate_series | generate_series
-----------------+-----------------
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 |
7 |
8 |
9 |
10 |
(10 registros)

how can i have the same in pg10 as i have had in pg 9.x?

I need it to date type to... if possible.

--
Att.
Márcio A. Sepp

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-01-09 05:19:24 Re: help with generation_series in pg10
Previous Message Michael Paquier 2018-01-09 00:51:27 Re: How Many Partitions are Good Performing