Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 605636337CE for ; Mon, 12 Apr 2010 12:56:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42781-02 for ; Mon, 12 Apr 2010 15:56:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail46.e.nsc.no (mail46.e.nsc.no [193.213.115.46]) by mail.postgresql.org (Postfix) with ESMTP id 6F1BC635742 for ; Mon, 12 Apr 2010 12:56:03 -0300 (ADT) Received: from balapapa.localnet (42.185.16.62.customer.cdi.no [62.16.185.42]) (authenticated bits=0) by mail46.nsc.no (8.14.3/8.14.3) with ESMTP id o3CFu1cH011698 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Mon, 12 Apr 2010 17:56:02 +0200 (MEST) From: Leif Biberg Kristensen To: pgsql-sql@postgresql.org Subject: Re: Table Design for Hierarchical Data Date: Mon, 12 Apr 2010 17:56:01 +0200 User-Agent: KMail/1.12.4 (Linux/2.6.32-gentoo-r7; KDE/4.3.5; i686; ; ) References: <201004121730.18837.leif@solumslekt.org> <4BC33E56.3000704@gmail.com> In-Reply-To: <4BC33E56.3000704@gmail.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <201004121756.01370.leif@solumslekt.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/46 X-Sequence-Number: 33973 On Monday 12. April 2010 17.37.58 Yeb Havinga wrote: > Leif Biberg Kristensen wrote: > > On Monday 12. April 2010 16.57.38 Rob Sargent wrote: > > > >> Believe me: "ego-ma-pa" will correctly define genealogical relationships > >> (at least among humans). > >> > > > > Yes, but a family tree is not a hierarchical tree as defined in database > > theory. Believe me: I'm a genealogist. > > > The last sentence is almost like the 'proof by authority' from 36 > methods of mathematical proof, see e.g. > http://jwilson.coe.uga.edu/EMT668/EMAT6680.F99/Challen/proof/proof.html. Sure, I'm also an autocephalic bishop of no fixed abode . Sorry that I forgot to mention that. :D regards, -- Leif Biberg Kristensen http://solumslekt.org/