select * from product where customer_id = (delete from product where product_id = 5 and customer_id =1 returning customer_id);错误:“”处或附近的语法错误
但是单独运行delete from product where product_id那么问题是子
我正在尝试将带有复杂查询的子查询从Oracle转换为Postgres。下面是子查询和它给出的错误。我知道“在团队中”也在Postgres。我遗漏了什么?我甚至将Listagg更改为String_agg,但得到了相同的错误。Select a, Listagg(b, ', ') WITHIN GROUP (ORDER BY b) "a"错误:
错误:..