coalesce函数判断oracle、postgresql中为null或者‘‘ 赋值默认

SELECT case
         when coalesce(a.fejshid, '0') = '0' then
          '0'
         when coalesce(a.fejshid, '0') = '' then
          '0'
         else
          a.fejshid
       end
  FROM T_DSSUBMIT A
 WHERE FSTATUS = '1'
   AND FISDEL = '0'
--coalesce函数判断oracle、postgresql中为null或者'' 赋值默认
1
2
3
4
5
6
7
8
9
10
11
12
13