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,提问作者임임병무
相关产品推荐
相关产品推荐

