判断postgre中null和空字符

1.name 为null时用122替换

select COALESCE(a.name,'122') from student a

2.name为空字符串替换成地址
select id,COALESCE(NULLIF(trim(name), ''), substring(address,0,8) || 'N') as from student