Re: Update query by joining multiple tables.

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Update query by joining multiple tables.
Date: 2007-01-17 12:55:11
Message-ID: 20070117125511.GC19527@phlogiston.dyndns.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)crankycanuck(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-01-17 12:58:57 Re: Postgresql & Oracle Heteregenous services - strange behaviour
Previous Message Marcin Stępnicki 2007-01-17 12:52:25 Postgresql & Oracle Heteregenous services - strange behaviour