X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 80A6FD1B57E for ; Wed, 29 Oct 2003 17:55:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 66887-10 for ; Wed, 29 Oct 2003 13:54:54 -0400 (AST) Received: from adsl-63-196-151-90.dsl.lsan03.pacbell.net (mail.valleypres.org [63.196.151.90]) by svr1.postgresql.org (Postfix) with ESMTP id 397B8D1B897 for ; Wed, 29 Oct 2003 13:54:53 -0400 (AST) Received: from smtp ([172.16.12.253] helo=valleypres.org) by adsl-63-196-151-90.dsl.lsan03.pacbell.net with esmtp (Exim 3.13 #5) id 1AEuWB-0007ZU-00; Wed, 29 Oct 2003 09:54:03 -0800 Received: from [172.16.31.147] (helo=AT10111) by valleypres.org with smtp (Exim 3.13 #3) id 1AEuW1-00025w-00; Wed, 29 Oct 2003 09:53:53 -0800 Reply-To: From: "Bryan Encina" To: "'Josh Berkus'" , "'Jeff Kowalczyk'" , Subject: Re: Help on update that subselects other records in table, uses joins Date: Wed, 29 Oct 2003 09:53:52 -0800 Message-ID: <002c01c39e45$9db08830$931f10ac@AT10111> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <200310290942.57584.josh@agliodbs.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/389 X-Sequence-Number: 15789 >I suggest Joe Conway's "SQL for Smarties" or "SQL Queries for Mere Mortals" >from another author. I could be mistaken, but I'm pretty sure Josh means Joe Celko's "SQL for Smarties" as I've seen him mention it before, and not Joe Conway. -b