Andrej Koelewijn

I’ve been using sql for a number of years now, and thought i knew most of the sql syntax. So i was quite surprised to find out about the existence of UPDATE … FROM. Turns out, this doesn’t exist in Oracle, but is supported by PostgreSQL.
Here’s a small example:

update response
set    house_id = ?
from   house [...]