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
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 |