RosettaCodeData/Task/Sort-numbers-lexicographically/DuckDB/sort-numbers-lexicographica...

8 lines
172 B
Plaintext

create or replace function lexorderedsequence(n) as table (
with cte as (
select i, i::VARCHAR as s
from range(1, n+1) t(i)
)
select i from cte order by s
);