postgresql7.1 select (CASE WHEN (select should_hire_p from recruiting_interviews i where i.interview_id = :interview_id) = 't' THEN 'Yes' WHEN (select should_hire_p from recruiting_interviews i where i.interview_id = :interview_id) = 'f' THEN 'No' END) as should_hire_p