** postgresql中case when 用法 SELECT CASE NAME WHEN ‘张三’ THEN ‘1’ WHEN ‘张四’ THEN ‘2’ ELSE’333’ END AS NAME FROM sys_user