Dan, > UPDATE commit_log_ports_elements X > SET X.needs_refresh = CLP.needs_refresh, > X.port_version = CLP.port_version, > X.port_revision = CLP.port_revision
FROM commit_log_ports CLP WHERE X.commit_log_id = CLP.commit_log_id You can always ask this kind of thing on IRC ..... -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org