Re: 3 tables join update - Mailing list pgsql-general

From rihad
Subject Re: 3 tables join update
Date
Msg-id 46FF5FF2.8060507@mail.ru
Whole thread Raw
In response to Re: 3 tables join update  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Richard Broersma Jr wrote:
> --- rihad <rihad@mail.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.

pgsql-general by date:

Previous
From: "CN"
Date:
Subject: Re: Please change default characterset for database cluster
Next
From: rihad
Date:
Subject: Re: 3 tables join update