Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 8CB976327E6 for ; Wed, 7 Apr 2010 05:27:01 -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 58050-10 for ; Wed, 7 Apr 2010 08:26:46 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f220.google.com (mail-ew0-f220.google.com [209.85.219.220]) by mail.postgresql.org (Postfix) with ESMTP id C90D2632315 for ; Wed, 7 Apr 2010 05:26:50 -0300 (ADT) Received: by ewy20 with SMTP id 20so407109ewy.21 for ; Wed, 07 Apr 2010 01:26:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:received:message-id:subject:to:cc:content-type; bh=lsZoPH+VltwjnCdIAj2S55S3Jo/sJhQqV5ORNx5FQ14=; b=sh4YRRBYmOPAefsZNDBuMMcEZHSo4cHd6aFYJBXSf4jP4x/oxgSq+3H/0ilyp0ZGjT M2SiLzYwmGry/wbophVuYskIyy15/4tHavqw81jfpuxE6cI+u41RLfOb0L8O1ova2bKy K13+svrR/RsqdTs7MRkaksVFqEWNRSZHLKof8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=vWJf1CBYIBprQ6uiogFUX+JncBtSGG3hWCqBfMBvSGQBXJ93kqIsrWAOHe78Yhl+Sp hWOF12WJqBmXmfp0YQmtiL9u5TnHiHCPT8+ONx+gk+oqLXkLpPbYg3L1KUTzTq6V5Crv oPQlu9qR6v9fryVXQAoLak9nGPRn2FDCV454E= MIME-Version: 1.0 Received: by 10.213.28.198 with HTTP; Wed, 7 Apr 2010 01:26:29 -0700 (PDT) In-Reply-To: References: From: Sergey Konoplev Date: Wed, 7 Apr 2010 12:26:29 +0400 Received: by 10.213.53.70 with SMTP id l6mr5128781ebg.45.1270628809125; Wed, 07 Apr 2010 01:26:49 -0700 (PDT) Message-ID: Subject: Re: Table Design for Hierarchical Data To: Lee Hachadoorian Cc: pgsql-sql Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.545 tagged_above=-10 required=5 tests=AWL=-0.805, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201004/19 X-Sequence-Number: 33946 On 6 April 2010 21:33, Lee Hachadoorian wrote: > More generally, what questions should I be asking to help decide what > structure makes the most sense? Are there any websites, forums, or books > that cover this kind of problem? Haven't you thought about ltree contrib? From the description of ltree: "This module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure". http://www.postgresql.org/docs/8.4/interactive/ltree.html -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com / Linkedin: http://ru.linkedin.com/in/grayhemp / JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802