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

Reply via email to