Is it possible to sort rows by values from generate_series()?
0
votes
1
answer
97
views
I multiply result rows of a
SELECT
with CROSS JOIN generate_series(1, max)
. My query is like:
~~~pgsql
select id, name
from person
CROSS JOIN generate_series(1, 4)
where ;
~~~
I have this result:
id|name
-|-
1|name1
1|name1
1|name1
1|name1
2|name2
2|name2
2|name2
2|name2
3|name3
3|name3
3|name3
3|name3
I want the result like this:
id|name
-|-
1|name1
2|name2
3|name3
1|name1
2|name2
3|name3
1|name1
2|name2
3|name3
1|name1
2|name2
3|name3
Is that possible?
Asked by nanocellule
(3 rep)
May 1, 2023, 09:13 PM
Last activity: May 2, 2023, 05:24 PM
Last activity: May 2, 2023, 05:24 PM