Did you know?

In PostgresQL you can update a row from a subQuery matches a condition.

You can even go wild by adding JOINS. 

see images