Re: Update Join Query

Daniel Futerman wrote:

> Is it possible to have UPDATE JOIN queries in PostgreSQL?

Yes:

UPDATE target
     ....
FROM othertable;

As far as I know Pg can only do an inner join on the update target. This
can be easily be turned into an outer join with something like:

UPDATE target
    ....
FROM target t LEFT OUTER JOIN othertable
WHERE target.id = t.id;

or similar. I haven't checked to see whether this results in an extra
scan in the query plan; you might want to use EXPLAIN ANALYZE to examine
how Pg will execute the query.

--
Craig Ringer