From: | Alexey M Boltenkov <padrebolt(at)yandex(dot)ru> |
---|---|
To: | SQL Padawan <sql_padawan(at)protonmail(dot)com>, "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Strange sequences - how to construct? |
Date: | 2021-10-23 13:54:07 |
Message-ID: | c2fae203-1e9f-bc35-5c0a-e684cdbdb56f@yandex.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
On 10/22/21 22:29, SQL Padawan wrote:
>
> 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 <https://protonmail.com/> Secure Email.
>
GENERATE_SERIES: select unnest(array[x, x]) x from generate_series(1, 5) x;
RECURSIVE CTE: with recursive x as ( select 1 x union all select x + 1
from x where x < 5) select unnest(array[x, x]) x from x;
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey M Boltenkov | 2021-10-23 13:59:19 | Re: Strange sequences - how to construct? |
Previous Message | Laura Smith | 2021-10-23 13:37:29 | Re: ZFS filesystem - supported ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey M Boltenkov | 2021-10-23 13:59:19 | Re: Strange sequences - how to construct? |
Previous Message | TIM CHILD | 2021-10-23 13:09:25 | Re: Strange sequences - how to construct? |