Postgres Pro
Downloads
Home   >   mailing lists

Re: Update query by joining multiple tables. - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Update query by joining multiple tables.
Date
Msg-id 20070117125511.GC19527@phlogiston.dyndns.org
Whole thread Raw
In response to Update query by joining multiple tables.  ("Moiz Kothari" <moizpostgres@gmail.com>)
Responses Re: Update query by joining multiple tables.  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-sql
Tree view 
On Wed, Jan 17, 2007 at 04:50:18PM +0530, Moiz Kothari wrote:
> http://www.postgresql.org/docs/8.1/interactive/sql-update.html, it is not
> specified if a join can be done between multiple tables to update a table, i

Sure it is:

A list of table expressions, allowing columns from other tables to
appear in the WHERE condition and the update expressions.

a

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Users never remark, "Wow, this software may be buggy and hard 
to use, but at least there is a lot of code underneath."    --Damien Katz

pgsql-sql by date:

Previous
From: Marcin Stępnicki
Date:
Subject: Postgresql & Oracle Heteregenous services - strange behaviour
Next
From: Andrew Sullivan
Date:
Subject: Re: Postgresql & Oracle Heteregenous services - strange behaviour