Strange sequences - how to construct?

Поиск
Список
Период
Сортировка
От SQL Padawan
Тема Strange sequences - how to construct?
Дата
Msg-id tiUZZ67DYCE5aY4wDAfIXjzlghyf4ndcG2m7wWRd0Rq3rtyhd38iJ9fN2iG088MxWOQtEBlEbsLXzqq-RUYer6rXXfS67pjdwthg8YRIgQU=@protonmail.com
обсуждение исходный текст
Ответы Re: Strange sequences - how to construct?  (TIM CHILD <tim.child@comcast.net>)
Re: Strange sequences - how to construct?  (TIM CHILD <tim.child@comcast.net>)
Re: Strange sequences - how to construct?  (Alexey M Boltenkov <padrebolt@yandex.ru>)
Re: Strange sequences - how to construct?  (Alexey M Boltenkov <padrebolt@yandex.ru>)
Список pgsql-novice

Good afternoon to everybody.

I wish to construct some weird sequences.

1
1
2
2
&c.

and with  3 ones, 4 ones... &c.

Now, I know how to do a simple
1
2
3
4

using both GENERATE_SERIES and using a RECURSIVE CTE.

What I would like is to be able to construct my specified sequences using *_both_* GENERATE_SERIES *_and_* RECURSIVE CTEs.

Regards,

SQL Padawan!




Sent with ProtonMail Secure Email.

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

Предыдущее
От: Nuno Sousa
Дата:
Сообщение: Re: Numeric Scale Differences
Следующее
От: TIM CHILD
Дата:
Сообщение: Re: Strange sequences - how to construct?