sql - “where”或附近的Postgresql语法错误

Question

我收到错误

syntax error at or near "where" LINE 5: where zip in (select zipcode from zips where city = 'Sacra

当我尝试运行此代码时。

update listings
set price = CASE WHEN (listings.price IS NOT NULL) THEN (price * 
(((100+(select price_change from zips where zips.zipcode=listings.zip))/100)))
where zip in (select zipcode from zips where city = 'Sacramento');

有人看到容易解决的错误吗？还是我想出了一些垃圾代码？

Answer 1

在子句之前的子句之前添加结束关键字

update listings
set price = CASE WHEN (listings.price IS NOT NULL) THEN (price * 
(((100+(select price_change from zips where zips.zipcode=listings.zip))/100))) END
where zip in (select zipcode from zips where city = 'Sacramento');

根据@a_horse_with_no_name的评论

update listings 
set price = (price * (((100+(select price_change from zips where zips.zipcode=listings.zip))/100))) 
where zip in (select zipcode from zips where city = 'Sacramento') and listings.price IS NOT NULL