update from sql statement
February 3rd, 2009 | by akoelewijn | published in oracle, oss
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 [...]
