Update Join Query - Mailing list pgsql-general

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.