You need to enable JavaScript to run this app. PostgreSQL报错syntax error at or near "ELSE" SQL语法问题排查
优惠活动
大模型
产品
解决方案
定价
更多

PostgreSQL报错syntax error at or near "ELSE" SQL语法问题排查

错误原因

  • 嵌套在WHEN b.pt_id = '12003'分支内的CONCAT_WS函数缺失右括号,结构不闭合,导致PostgreSQL无法正确识别外层CASE后续的ELSE关键字,触发语法报错
  • 外层CASE语句结束后、别名prop_value1_view前缺少必要的闭合END关键字
  • b.group_seq和后续的FROM关键字连写,没有空格分隔,也会触发语法错误

修正后的SQL语句

SELECT 
    b.mo_id,
    b.ot_id, 
    (select ot_name from object_type where ot_id = b.ot_id) ot_name,
    a.obj_id, 
    b.pt_id, 
    b.pt_name, 
    b.data_type, 
    a.prop_value1,
    CASE
        WHEN b.data_type = '2'
            THEN (SELECT code_name FROM site_code WHERE group_seq = b.group_seq AND code_seq = a.prop_value1)
        WHEN b.data_type = '3' 
            THEN TO_CHAR(a.prop_value1,'999,999,999,999,999')
        WHEN b.data_type = '5' AND a.prop_value1 is not null 
            THEN TO_CHAR(to_date(a.prop_value1,'YYYYMMDD'),'YYYY/MM/DD')
        WHEN b.data_type = '6' 
            THEN TO_CHAR(a.prop_value1,'999,999,999,999,999')
        WHEN b.pt_id = '12003' 
            THEN CONCAT_WS('', SUBSTR(a.prop_value1,0,18), CASE WHEN length(a.prop_value1) > 18 THEN '...' ELSE '' END)
        ELSE a.prop_value1 
    END AS prop_value1_view, 
    b.pt_order, 
    b.default_yn, 
    b.list_yn, 
    b.align, 
    b.group_seq
FROM 
    (SELECT * FROM property_type WHERE ot_id = #otId# AND list_yn = '1') b 
LEFT OUTER JOIN
    (SELECT * from property where ot_id = #otId# AND obj_id = '') a 
    ON a.ot_id = b.ot_id AND a.pt_id = b.pt_id 
ORDER BY b.pt_order

内容的提问来源于stack exchange,提问作者임임병무

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.09 11:18:03