ERROR: syntax error at or near "status" at character 11
LINE 1: SELECT IF status = 'L' THEN edate ELSEIF status = 'C' THEN '...
SELECT
CASE status
WHEN 'L' THEN edate
WHEN 'C' THEN 'wrong date'
END as date
FROM
campaigns;