By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t as
select 'store1' as store, 'item1' as item, 2 as value union all
select 'store1' as store, 'item2' as item, 3 as value
✓
with recursive cte(store, item, value, n) as (
select store, item, value, 0
from t
union all
select store, item, value, n + 1
from cte
where n < value
)
select store, item, n as value
from cte;
| store | item | value |
|---|---|---|
| store1 | item1 | 0 |
| store1 | item2 | 0 |
| store1 | item1 | 1 |
| store1 | item2 | 1 |
| store1 | item1 | 2 |
| store1 | item2 | 2 |
| store1 | item2 | 3 |