case when postgres

     CASE 
      WHEN condition_1  THEN result_1
      WHEN condition_2  THEN result_2
      [WHEN ...]
      [ELSE else_result]
END

CASE WHEN condition THEN result
     [WHEN ...]
     [ELSE result]
END