Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6F1809FA0C0 for ; Fri, 2 Feb 2007 23:31:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 79777-06 for ; Fri, 2 Feb 2007 23:31:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id DDD339F9F49 for ; Fri, 2 Feb 2007 23:31:29 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l133VHYQ026886; Fri, 2 Feb 2007 22:31:17 -0500 (EST) To: Kirk Wythers cc: "Luke Lonergan" , "Steinar H. Gunderson" , "=?ISO-8859-1?Q? " _ " _G=E1briel_=C1kos_ " _ " ?=" , pgsql-performance@postgresql.org Subject: Re: trouble with a join on OS X In-reply-to: <7CF821AD-20DA-4CC7-8A05-5B778B164327@umn.edu> References: <293ED31C-0866-4616-9D44-A22D8111E57C@umn.edu> <26430.1170469932@sss.pgh.pa.us> <7CF821AD-20DA-4CC7-8A05-5B778B164327@umn.edu> Comments: In-reply-to Kirk Wythers message dated "Fri, 02 Feb 2007 21:19:15 -0600" Date: Fri, 02 Feb 2007 22:31:17 -0500 Message-ID: <26885.1170473477@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.42 tagged_above=0 required=5 tests=AWL, BAD_ENC_HEADER, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/42 X-Sequence-Number: 23096 Kirk Wythers writes: > The new table needs to be filled with the results of the join. If > there is a way to do this without a SELECT, please share. If it's an entirely new table, then you probably want to use INSERT ... SELECT. If what you want is to update existing rows using a join, you can use UPDATE ... FROM (not standard) or something involving a sub-select. You'd need to state your problem in some detail to get more help than that... regards, tom lane