dekstop

CREATE OR REPLACE FUNCTION get_cohort(TEXT) RETURNS TEXT AS $$
    BEGIN
        RETURN CASE 
            WHEN $1 ILIKE '%Missing Maps%' OR $1 ILIKE '%MissingMaps%' THEN 'Missing Maps'
            WHEN $1 ILIKE '%Ebola%' THEN 'Ebola response'
            WHEN $1 ILIKE '%Kaligandaki%' AND $1 ILIKE '%Landslide%' THEN 'Kaligandaki landslide'
            WHEN $1 ILIKE '%Nepal%' OR $1='<strong> IDP informal camps</strong>' THEN 'Nepal earthquake'
            -- WHEN $1 ILIKE '%Nepal%' OR $1 ILIKE '%Kaligandaki%' OR $1='<strong> IDP informal camps</strong>' THEN 'Nepal earthquake'
            WHEN $1 ILIKE '%Central African Republic%' OR $1 LIKE '%CAR%' THEN 'CAR'
            WHEN $1 ILIKE '%South Sudan%' THEN 'South Sudan'

dekstop

2 Broke Girls
30 Rock
Awake
Black Mirror
Boardwalk Empire
Bored to Death
Borgen
Breaking Bad
Broad City
Bron, Broen

dekstop

 228 (none)
 208 aqi
 179 ozone
 169 pm2.5
  70 1
  41 2
  25 CO
  24 NO2
  23 temperature
  23 humidity

dekstop

Hey all,

As you may have heard we're organising a UK camping festival later this Summer: Electromagnetic Field 2012. We are now searching for contributors to give talks, workshops, and performances. We're also inviting communities to participate by forming camp villages.

More details on ticket sales will follow soon: follow @emfcamp for updates.

---

EMF 2012 CALL FOR PARTICIPATION

dekstop

Gems included by the bundle:
  * abstract (1.0.0)
  * actionmailer (3.0.1)
  * actionpack (3.0.1)
  * activemodel (3.0.1)
  * activerecord (3.0.1)
  * activeresource (3.0.1)
  * activesupport (3.0.1)
  * arel (1.0.1)
  * builder (2.1.2)