postgresql中sql查询语句报错处理——ERROR: failed to find conversion function from unknown to text
查询中起别名的原因
-- 修改前sq SELECT cc.* FROM ( SELECT SUM ( dateDb.jg ) AS jg, '督院街街道办事处' AS xzqhName, '510104020000' AS xzqhCode , CASE WHEN ( SELECT COUNT ( * ) FROM yzt2000db.PUBLIC.jc_ch_dlst_xzq_h_pg_2017 WHERE xzqdm LIKE'510104020000' || '%' AND xzqdm != '510104020000' AND CHAR_LENGTH ( xzqdm ) = CHAR_LENGTH ( '510104020000' ) + 3 ) > 0 THEN 1 ELSE NULL END AS hasChildren FROM PUBLIC.zt_ly_jzdj_pg AS dateDb WHERE dateDb.fqdm LIKE'510104020000%' ) cc ORDER BY xzqhcode
修改后sql在报错地方转了text() SELECT cc.* FROM ( SELECT SUM ( dateDb.jg ) AS jg, '督院街街道办事处' AS xzqhName, text('510104020000') AS xzqhCode , CASE WHEN ( SELECT COUNT ( * ) FROM yzt2000db.PUBLIC.jc_ch_dlst_xzq_h_pg_2017 WHERE xzqdm LIKE'510104020000' || '%' AND xzqdm != '510104020000' AND CHAR_LENGTH ( xzqdm ) = CHAR_LENGTH ( '510104020000' ) + 3 ) > 0 THEN 1 ELSE NULL END AS hasChildren FROM PUBLIC.zt_ly_jzdj_pg AS dateDb WHERE dateDb.fqdm LIKE'510104020000%' ) cc ORDER BY xzqhcode