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