PostgreSQL 按指定顺序排序

因为PostgreSql没有order by field 所以按照指定的顺序排序就没有这么简单了，可以使用case when then进行排序

示例一

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