RE: [GENERAL] Correlated subquery/update

[Nick Fankhauser]

Sounds like the answer is to upgrade to v7+ 

Much thanks to Tom Lane and Len Morgan for the helpful responses! 

-Nick

>update one set b = (select d from two where one.a = two.c);