From: Leif Biberg Kristensen <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: Table Design for Hierarchical Data
Date: Mon, 12 Apr 2010 17:30:18 +0200
Message-ID: <201004121730.18837.leif@solumslekt.org> (raw)
In-Reply-To: <4BC334E2.6020600@gmail.com>
References: <n2i5ab13581004061033j4ed25734xd0504cb95a1fc092@mail.gmail.com>
<201004121114.10189.achill@matrix.gatewaynet.com>
<4BC334E2.6020600@gmail.com>
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.
Hint: Where is the root node of a family tree? Old Adam & Eve?
On the other hand, a pedigree may be considered a true binary tree with a root
node, the proband.
regards,
--
Leif Biberg Kristensen
http://solumslekt.org/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: leif@solumslekt.org
Subject: Re: Table Design for Hierarchical Data
In-Reply-To: <201004121730.18837.leif@solumslekt.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox