This post originated from an RSS feed registered with Java Buzz
by Andrej Koelewijn.
Original Post: update from sql statement
Feed Title: Andrej Koelewijn
Feed URL: http://feeds.feedburner.com/AndrejKoelewijn
Feed Description: On Oracle, Java and OpenSource
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 [...]