On 16 Jun 2009, at 16:17, Richard Huxton wrote: > > PostgreSQL has the useful but non-standard FROM clause for updates: > UPDATE info SET uid = newuid FROM xfer WHERE uid = xfer.olduid; > MySQL has this in a different form. Search the docs for UPDATE syntax