Re: Update Join Query

[Mark Roberts <mailing_lists@xxxxxxxxxxxxxxx>]

update foo
set foo_id = g.goo_id
from goo g
where foo.foo_id = g.goo_id and foo.foo_id is not null

I think. :)

-Mark

On Mon, 2008-06-23 at 21:43 +0200, Daniel Futerman wrote:
> Hi,
> 
> Looking for the correct syntax for an UPDATE LEFT JOIN query in
> PostgreSQL.
> 
> The equivalent MySQL query is :
> 
>     UPDATE
>         Foo f LEFT JOIN Goo g on f.Foo_ID = g.Goo_ID
>     SET
>         f.Foo_ID = g.Goo_ID
>     WHERE
>         f.Foo_ID IS NOT NULL;
> 
> 
>  When I try to run this in Postgres, i get the following error:
> 
> ERROR:  syntax error at or near "LEFT"
> 
> Is it possible to have UPDATE JOIN queries in PostgreSQL?
> 
> Thanks.