help with generation_series in pg10

Поиск
Список
Период
Сортировка
От Márcio A. Sepp
Тема help with generation_series in pg10
Дата
Msg-id 00bb01d388e8$c9607b50$5c2171f0$@com.br
обсуждение исходный текст
Ответы Re: help with generation_series in pg10  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: help with generation_series in pg10  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: How Many Partitions are Good Performing
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: help with generation_series in pg10