X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CE618D1B528 for ; Wed, 8 Oct 2003 23:40:37 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 66954-09 for ; Wed, 8 Oct 2003 20:39:54 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id B8D58D1B4EE for ; Wed, 8 Oct 2003 20:39:50 -0300 (ADT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3743138; Wed, 08 Oct 2003 16:40:30 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Dan Langille , pgsql-sql@postgresql.org Subject: Re: UPDATE one table with values from another Date: Wed, 8 Oct 2003 16:37:57 -0700 User-Agent: KMail/1.4.3 References: <20031008180813.X53328@xeon.unixathome.org> In-Reply-To: <20031008180813.X53328@xeon.unixathome.org> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200310081637.57591.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/98 X-Sequence-Number: 15498 Dan, > UPDATE commit_log_ports_elements X > SET X.needs_refresh =3D CLP.needs_refresh, > X.port_version =3D CLP.port_version, > X.port_revision =3D CLP.port_revision FROM commit_log_ports CLP WHERE X.commit_log_id =3D CLP.commit_log_id You can always ask this kind of thing on IRC ..... --=20 -Josh Berkus Aglio Database Solutions San Francisco