X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E16453A4B04 for ; Fri, 26 Nov 2004 21:36:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47764-04 for ; Fri, 26 Nov 2004 21:36:28 +0000 (GMT) Received: from smtp101.rog.mail.re2.yahoo.com (smtp101.rog.mail.re2.yahoo.com [206.190.36.79]) by svr1.postgresql.org (Postfix) with SMTP id 585483A4B30 for ; Fri, 26 Nov 2004 21:36:28 +0000 (GMT) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@65.49.125.184 with login) by smtp101.rog.mail.re2.yahoo.com with SMTP; 26 Nov 2004 21:36:26 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 4F79C412E; Fri, 26 Nov 2004 16:36:25 -0500 (EST) Date: Fri, 26 Nov 2004 16:36:25 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Way to stop recursion? Message-ID: <20041126213625.GC2312@phlogiston.dyndns.org> Mail-Followup-To: pgsql-sql@postgresql.org References: <41A79A2A.6070606@delegated.net> <19345.1101504671@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <19345.1101504671@sss.pgh.pa.us> User-Agent: Mutt/1.5.6+20040722i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/270 X-Sequence-Number: 19588 On Fri, Nov 26, 2004 at 04:31:11PM -0500, Tom Lane wrote: > > Seems to me that your real problem is a bogus database layout. If there > should only be one "common" value for a parent and children, then only > store one value ... that is, "common" should exist only in the parent. Tom's answers always make me realise that I should think harder before I talk. He's right, of course: one common value means store it once. A -- Andrew Sullivan | ajs@crankycanuck.ca I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin