Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D41A2634C12 for ; Wed, 7 Apr 2010 05:07:44 -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 55481-05 for ; Wed, 7 Apr 2010 08:07:30 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f210.google.com (mail-ew0-f210.google.com [209.85.219.210]) by mail.postgresql.org (Postfix) with ESMTP id AA9D3632EBA for ; Wed, 7 Apr 2010 05:06:43 -0300 (ADT) Received: by ewy2 with SMTP id 2so403618ewy.16 for ; Wed, 07 Apr 2010 01:06:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=u6g8F0EZbTn2StxY9kpqDFzSoYroxG6PXEevnYjiuCg=; b=VMGgJN7boGdBdJTZrgDbCPqZYb2tYPWfSPfO9JwmrFjMWuy1zAm/z6Axud27DozGA2 QfrnT3UghUWi2M9E25CaUpdijeiXtIPwR3JjxzlbN8DLBw5o2jaH23Km01QlkKyV7rnX lXsQHzLSRp46Sb8tk9CdLZ2wBlw3Ncmj5uvkw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=oTUqDoi+N1b9E5BGh5vzgNOWj91aT/WuPGkLqTn3GceFOnmdYaBL1+VoTzZsn+a6z7 Qm74At3DmKxcOYYskWH9AhBNwKZ1FL+K1E8r3Hg8WJznfyL18WqaN+iHCgfE/7Pgc67m 1Y7yizlm/L2v5A5tuDX72u6ErxJfPf00hzCG8= Received: by 10.213.42.194 with SMTP id t2mr5121694ebe.50.1270627602147; Wed, 07 Apr 2010 01:06:42 -0700 (PDT) Received: from [0.0.0.0] (5357DA75.cable.casema.nl [83.87.218.117]) by mx.google.com with ESMTPS id 16sm7877519ewy.15.2010.04.07.01.06.40 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 07 Apr 2010 01:06:41 -0700 (PDT) Message-ID: <4BBC3D14.8080401@gmail.com> Date: Wed, 07 Apr 2010 10:06:44 +0200 From: Yeb Havinga User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Achilleas Mantzios CC: pgsql-sql@postgresql.org Subject: Re: Table Design for Hierarchical Data References: <201004071000.15529.achill@matrix.gatewaynet.com> In-Reply-To: <201004071000.15529.achill@matrix.gatewaynet.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.388 tagged_above=-10 required=5 tests=AWL=0.211, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201004/18 X-Sequence-Number: 33945 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? regards, Yeb Havinga