PostgreSQL 按指定順序排序

SELECT stage, pln_status
FROM project
ORDER BY CASE 
  WHEN pln_status = '規劃' THEN 1
  WHEN pln_status = '初選' THEN 2
  WHEN pln_status = '查勘' THEN 3
  WHEN pln_status = '評審' THEN 4
  WHEN pln_status = '批複' THEN 5
  WHEN pln_status = '初設' THEN 6
  WHEN pln_status = '開工' THEN 7
END      

SELECT *
FROM person
ORDER BY CASE constellation
  WHEN '白羊' THEN 1
  WHEN '金牛' THEN 2
  WHEN '雙子' THEN 3
  WHEN '巨蟹' THEN 4
  WHEN '獅子' THEN 5
  WHEN '處女' THEN 6
  WHEN '天秤' THEN 7
  WHEN '天蠍' THEN 8
  WHEN '射手' THEN 9
  WHEN '摩羯' THEN 10
  WHEN '水瓶' THEN 11
  WHEN '雙魚' THEN 12
END DESC