psql case code example

Example 1: case when postgres

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

Example 2: case when postgres

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