postgresql case

select schedule.*, 
cast(schedule.计划描述 as varchar) as 描述 ,job.名称 as 作业名称,
CASE CAST( 执行方式 as VARCHAR )
WHEN '0' then CAST('仅触发器触发' as VARCHAR ) 
WHEN '1' then  CAST('执行一次' as VARCHAR )  
WHEN '2' then  CAST('每天执行' as VARCHAR ) 
else '未知状态' end
执行方式_
from schedule 
LEFT JOIN job on job.作业id=schedule.作业id
where schedule.删除标识='0' 
order by 计划id