Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id E9ADC63238C for ; Wed, 7 Apr 2010 05:39:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 59953-09 for ; Wed, 7 Apr 2010 08:39:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211]) by mail.postgresql.org (Postfix) with ESMTP id 026AC6310AC for ; Wed, 7 Apr 2010 05:39:44 -0300 (ADT) Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.2/8.14.2) with ESMTP id o378dhnJ054238 for ; Wed, 7 Apr 2010 11:39:43 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by smadev.internal.net (8.14.2/8.14.2/Submit) id o378dgHr054237 for pgsql-sql@postgresql.org; Wed, 7 Apr 2010 11:39:42 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-sql@postgresql.org Subject: Re: Table Design for Hierarchical Data Date: Wed, 7 Apr 2010 10:39:41 +0200 User-Agent: KMail/1.9.7 References: <201004071000.15529.achill@matrix.gatewaynet.com> <4BBC3D14.8080401@gmail.com> In-Reply-To: <4BBC3D14.8080401@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <201004071139.42140.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.09 tagged_above=-10 required=5 tests=AWL=-0.905, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201004/22 X-Sequence-Number: 33949 =CE=A3=CF=84=CE=B9=CF=82 Wednesday 07 April 2010 11:06:44 =CE=BF/=CE=B7 Yeb= Havinga =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > 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 r= oot are depicted as > > parents[0] : immediate parent > > parents[1] : immediate parent of the above parent > > =20 > What I have more than one parent? Then it is no longer neither a tree, nor a hierarchical structure, but rath= er a graph. This a totally different problem. >=20 > regards, > Yeb Havinga >=20 >=20 =2D-=20 Achilleas Mantzios