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