By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t (foo varchar(10), bar varchar(10));
insert into t (foo, bar) values ('abc', 'def'), ('ghi', 'jkl');
Records: 2 Duplicates: 0 Warnings: 0
with recursive g (n) as (select 1 union all select n + 1 from g where n < 5)
select g.n as slot, x.foo, x.bar
from g
left join (select t.*, row_number() over() as rn from t) x on x.rn = g.n
| slot | foo | bar |
|---|---|---|
| 1 | abc | def |
| 2 | ghi | jkl |
| 3 | null | null |
| 4 | null | null |
| 5 | null | null |