Re: Update Join Query

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.