Discussion on: Daily Challenge #2 - String Diamond

\set x 5

select concat(repeat(' ', :x - n), repeat('*',2 * n + 1))
   from (select * from generate_series(0, :x) as n
     union all
         select * from generate_series(:x - 1, 0, -1) as n) as n;