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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
