| From: | SQL Padawan <sql_padawan(at)protonmail(dot)com> |
|---|---|
| To: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Strange sequences - how to construct? |
| Date: | 2021-10-22 19:29:58 |
| Message-ID: | tiUZZ67DYCE5aY4wDAfIXjzlghyf4ndcG2m7wWRd0Rq3rtyhd38iJ9fN2iG088MxWOQtEBlEbsLXzqq-RUYer6rXXfS67pjdwthg8YRIgQU=@protonmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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](https://protonmail.com/) Secure Email.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2021-10-22 21:09:48 | Re: Looking for a doc section that presents the overload selection rules |
| Previous Message | Bryn Llewellyn | 2021-10-22 18:41:17 | Re: Looking for a doc section that presents the overload selection rules |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | TIM CHILD | 2021-10-22 23:01:14 | Re: Strange sequences - how to construct? |
| Previous Message | Nuno Sousa | 2021-10-21 15:26:26 | Re: Numeric Scale Differences |