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 2CC3BD1B8A3 for ; Fri, 5 Sep 2003 20:12:40 +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 19784-08 for ; Fri, 5 Sep 2003 17:12:08 -0300 (ADT) Received: from web4.betterthanyours.com (unknown [63.220.222.33]) by svr1.postgresql.org (Postfix) with ESMTP id 8E39AD1D127 for ; Fri, 5 Sep 2003 14:40:25 -0300 (ADT) Received: from [65.82.122.144] (helo=fig) by web4.betterthanyours.com with asmtp (Exim 4.20) id 19vKZL-0008Hf-Fp; Fri, 05 Sep 2003 13:40:23 -0400 Reply-To: From: To: "Pgsql-Sql" Cc: "Gregory S. Dodson" , "Josh Wardle" Subject: recursive sql Date: Fri, 5 Sep 2003 12:41:26 -0500 Message-ID: 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 IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - web4.betterthanyours.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - 4peakstech.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=BAYES_30, MSGID_GOOD_EXCHANGE, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200309/33 X-Sequence-Number: 15011 can anyone recommend a good reference source for doing recursive sql on postgresql? i want to do something similar to a BOM expansion. (i.e. i need to traverse a self-referencing table that stores a tree structure and answer a question like "Get me A and all of A's descendents") Regards, Floyd Shackelford 4 Peaks Technology Group, Inc. VOICE: 334.735.9428 FAX: 702.995.6462 EMAIL: FloydS@4PeaksTech.com ICQ #: 161371538 PGP Key ID: 0x2E84F2F2 PGP Fone at private.fwshackelford.com on request Shackelford Motto: ACTA NON VERBA - Actions, not words Alabama StateMotto: AUDEMUS JURA NOSTRA DEFENDERE - We Dare Defend Our Rights The Philosophy of Liberty: http://www.isil.org/resources/introduction.swf "We have allowed our constitutional republic to deteriorate into a virtually unchecked direct democracy. Today's political process is nothing more than a street fight between various groups seeking to vote themselves other people's money. Individual voters tend to support the candidate that promises them the most federal loot in whatever form, rather than the candidate who will uphold the rule of law." --Rep. Ron Paul