查询pg库富文本中文数量

SELECT
    case_name,d.dict_table_name,
    LENGTH(REGEXP_REPLACE(b.content, '<[^>]*>', '', 'g'))AS casesummary ,
    LENGTH(REGEXP_REPLACE(c.content, '<[^>]*>', '', 'g'))AS backgroundcount 
FROM
    "t05_social_responsibility"
    A LEFT JOIN members.t05_text_info b ON A.case_summary = b.text_id
    LEFT JOIN members.t05_text_info C ON A.case_background = C.text_id 
    left join public.t00_dim d on  a.submission_caty = d.dim_code
WHERE
    A.selected_flag = 'true'   
ORDER BY d.sorter,case_name