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 99F38D1B4F4 for ; Thu, 9 Oct 2003 03:41:43 +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 19236-02 for ; Thu, 9 Oct 2003 00:40:54 -0300 (ADT) Received: from xeon.unixathome.org (bast.unixathome.org [66.11.174.150]) by svr1.postgresql.org (Postfix) with ESMTP id 88AB0D1B4F6 for ; Thu, 9 Oct 2003 00:40:53 -0300 (ADT) Received: by xeon.unixathome.org (Postfix, from userid 1000) id 7EDC93E4F; Wed, 8 Oct 2003 23:41:31 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by xeon.unixathome.org (Postfix) with ESMTP id 7435A3E4E; Wed, 8 Oct 2003 23:41:31 -0400 (EDT) Date: Wed, 8 Oct 2003 23:41:31 -0400 (EDT) From: Dan Langille X-X-Sender: dan@xeon.unixathome.org To: Josh Berkus Cc: pgsql-sql@postgresql.org Subject: Re: UPDATE one table with values from another In-Reply-To: <200310081637.57591.josh@agliodbs.com> Message-ID: <20031008233756.O93934@xeon.unixathome.org> References: <20031008180813.X53328@xeon.unixathome.org> <200310081637.57591.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/100 X-Sequence-Number: 15500 On Wed, 8 Oct 2003, Josh Berkus wrote: > 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 Thanks Josh. After a 5 hour drive to Hamilton, my brain was only capable of doing the email. > You can always ask this kind of thing on IRC ..... If I'd been at home, I would have. This laptop of mine is getting pretty old. It took pretty close to 15 minutes for it to set a field to zero in 91,295 rows.... I need more ram and a faster laptop! cheers