Oracle
decode():select decode(student_name,‘乱七八糟’,null,student_name) from student_info
结果:当给的student_name是"乱七八糟",则查询的结果为null,否则查询出来的结果为student_name
等价于
Postgresql:
case when:select case when student_name= ‘乱七八糟’ then null else student_name end from student_info
附:
decode(A,1,11,a,aa,bb)
相当于
case when A=1 then 11 when A=a then aa else bb end