Sample Header Ad - 728x90

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