Skip to content

Instantly share code, notes, and snippets.

@CatTrinket
Last active August 29, 2015 14:05
Show Gist options
  • Save CatTrinket/f2025b741229626651fa to your computer and use it in GitHub Desktop.
Save CatTrinket/f2025b741229626651fa to your computer and use it in GitHub Desktop.
Pokémon names that are at least eleven characters (actual game languages that don't reuse English names)
pokedex=> select l.identifier lang, ps.identifier pokemon, psn.name from pokemon_species_names psn join pokemon_species ps on psn.pokemon_species_id=ps.id join languages l on psn.local_language_id=l.id where length(name) >= 11 and l.identifier not in ('roomaji', 'es', 'it') order by l.order, ps.order;
lang | pokemon | name
------+-------------+--------------
en | fletchinder | Fletchinder
fr | chesnaught | Blindépique
fr | diggersby | Excavarenne
fr | scatterbug | Lépidonille
fr | skiddo | Cabriolaine
fr | pancham | Pandespiègle
fr | slurpuff | Cupcanaille
fr | trevenant | Desséliande
fr | gourgeist | Banshitrouye
fr | noibat | Sonistrelle
de | quilladin | Igastarnish
de | swirlix | Flauschling
(12 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment