postgresql 判断字段是否为空

select COALESCE(tran.rm_amt,0) rm_amt

select COALESCE(null, 0) as test

结果

test

0