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