Re: Update query by joining multiple tables.

Might be a view and then a rule attached with that can help you out with
doing updates using joins

--------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/17/07, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>