Skip site navigation (1) Skip section navigation (2)

Re: 3 tables join update

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 3 tables join update
Date: 2007-09-30 08:36:02
Message-ID: 46FF5FF2.8060507@mail.ru (view raw or flat)
Thread:
Lists: pgsql-general
Richard Broersma Jr wrote:
> --- rihad <rihad(at)mail(dot)ru> wrote:
>> UPDATE Foo foo
>> SET foo.baz_id=baz.id
>> FROM Baz baz LEFT JOIN Bar bar ON (foo.bar_id=bar.id)
>> WHERE bar.id IS NULL;
> 
> This query cannot work.


I know. So how do I do it efficiently?

Thanks.

In response to

pgsql-general by date

Next:From: rihadDate: 2007-09-30 09:01:30
Subject: Re: 3 tables join update
Previous:From: CNDate: 2007-09-30 03:55:00
Subject: Re: Please change default characterset for database cluster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group