使用该函数会把字符串转为可计算
select sum(code::numeric(20,2)) from sv_jianzhu
把列值为null指定为其他数据’
SELECT
COALESCE ( t2.TYPE, '' ) AS TYPE,
COALESCE ( t2.fid, '' ) AS wybsm
FROM
projdata t1
LEFT JOIN sv_jianzhu t2 ON t1.code = t2.code
使用该函数会把字符串转为可计算
select sum(code::numeric(20,2)) from sv_jianzhu
把列值为null指定为其他数据’
SELECT
COALESCE ( t2.TYPE, '' ) AS TYPE,
COALESCE ( t2.fid, '' ) AS wybsm
FROM
projdata t1
LEFT JOIN sv_jianzhu t2 ON t1.code = t2.code