Re: Table Design for Hierarchical Data

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Table Design for Hierarchical Data
Date: 2010-04-12 15:30:18
Message-ID: 201004121730.18837.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Yeb Havinga 2010-04-12 15:37:58 Re: Table Design for Hierarchical Data
Previous Message Rob Sargent 2010-04-12 14:57:38 Re: Table Design for Hierarchical Data