Postgres Pro
Downloads
Home   >   mailing lists

Re: Table Design for Hierarchical Data - Mailing list pgsql-sql

From Leif Biberg Kristensen
Subject Re: Table Design for Hierarchical Data
Date
Msg-id 201004121730.18837.leif@solumslekt.org
Whole thread Raw
In response to Re: Table Design for Hierarchical Data  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Table Design for Hierarchical Data  (Yeb Havinga <yebhavinga@gmail.com>)
List pgsql-sql
Tree view 
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/

pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Table Design for Hierarchical Data
Next
From: Yeb Havinga
Date:
Subject: Re: Table Design for Hierarchical Data