Dave Jarvis' Repositories

select
  pp.id,
  pp.label_singular,
  pp.label_plural,
  pp.uncountable,
  pp.countable,
  pp.singular_measure,
  rin.id,
  rin.label,
  trim( trailing label_singular from rin.label ) || pp.label_plural as label_pluralized,
  'http://en.wiktionary.org/wiki/'||rin.label as wiktionary,
  'http://en.wikipedia.org/wiki/'||rin.label as wikipedia,
  'http://www.learnersdictionary.com/definition/'||rin.label as learners
from
  pluralize.plural pp,
  recipe.ingredient_name_vw rin
where
  rin.label ilike '%'||pp.label_singular and
  pp.indeterminate = false and
  pp.countable = true and
  pp.uncountable = false
order by
  pp.label_singular;