Re: Table Design for Hierarchical Data

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Table Design for Hierarchical Data
Date: 2010-04-07 08:39:41
Message-ID: 201004071139.42140.achill@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Στις 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.

>
> regards,
> Yeb Havinga
>
>

--
Achilleas Mantzios

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Lee Hachadoorian 2010-04-07 18:27:37 Re: Table Design for Hierarchical Data
Previous Message Achilleas Mantzios 2010-04-07 08:34:24 Re: Table Design for Hierarchical Data