79389030

Date: 2025-01-26 18:06:03
Score: 1
Natty:
Report link

Use (controlled!) recursivity:

with recursive v as
(
    select id, min val, max from a
    union
    select id, val + 1, max from v where val < max
)
select id, val from v;

See it running live.

Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Guillaume Outters