Schemaverse Planet Rename Demonstration

schemaverse_planet_rename_demo.sql

select row_number, ( case row_number % 12
    when 0 then 'Aethra'
    when 1 then 'Mony'
    when 2 then 'Semper'
    when 3 then 'Voit'
    when 4 then 'Lester'
    when 5 then 'Rio'
    when 6 then 'Zergon'
    when 7 then 'Cannibalon'
    when 8 then 'Omicron Persei'
    when 9 then 'Urectum'
    when 10 then 'Wormulon'
    when 11 then 'Kepler'
end ) || '_' || ( ( row_number / 12 ) + 1 )::text
from generate_series( 0, 12 ) as row_number;

-- schemaverse planet naming demonstration