RosettaCodeData/Task/String-append/DuckDB/string-append-1.duckdb
2025-08-11 18:05:26 -07:00

8 lines
146 B
Text

with recursive t(i, s) as (
select 0, 'foo'
union all
select i+1, s || 'bar'
from t
where i < 1)
select last(s order by i) as s
from t;