Re: UPDATE one table with values from another

On Wed, 8 Oct 2003, Josh Berkus wrote:

> > UPDATE commit_log_ports_elements X
IIRC, PostgreSQL doesn't like aliases of the
update table, so I think you'll need to spell it
out in the WHERE.

> >    SET X.needs_refresh = CLP.needs_refresh,
> >        X.port_version  = CLP.port_version,
> >        X.port_revision = CLP.port_revision
I don't think you need the X.'s here anyway, there's
only one update table.