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

From Yeb Havinga
Subject Re: Table Design for Hierarchical Data
Date
Msg-id 4BBCEC03.3050100@gmail.com
Whole thread Raw
In response to Re: Table Design for Hierarchical Data  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: Table Design for Hierarchical Data
List pgsql-sql
Achilleas Mantzios wrote:
> Στις Wednesday 07 April 2010 11:06:44 ο/η Yeb Havinga έγραψε:
>   
>> Achilleas Mantzios wrote:
>>     
>>> You could also consider the genealogical approach, e.g.
>>>
>>>
>>> The parents of any node to the root, i.e. the path of any node to the root are depicted as
>>> parents[0] : immediate parent
>>> parents[1] : immediate parent of the above parent
>>>   
>>>       
>> What I have more than one parent?
>>     
>
> Then it is no longer neither a tree, nor a hierarchical structure, but rather a graph.
> This a totally different problem.
>   
My question was actually an attempt to point at the inability of what 
you call the 'genealogical approach' database design to store 
information of more than one parent.

regards,
Yeb Havinga



pgsql-sql by date:

Previous
From: Lee Hachadoorian
Date:
Subject: Re: Table Design for Hierarchical Data
Next
From: Achilleas Mantzios
Date:
Subject: Re: Table Design for Hierarchical Data