From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-sql@postgresql.org
Subject: Re: Table Design for Hierarchical Data
Date: Wed, 7 Apr 2010 10:34:24 +0200
Message-ID: <201004071134.25176.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <w2yc3a7de1f1004070126o74fdebe3y762b67323e888523@mail.gmail.com>
References: <n2i5ab13581004061033j4ed25734xd0504cb95a1fc092@mail.gmail.com>
<w2yc3a7de1f1004070126o74fdebe3y762b67323e888523@mail.gmail.com>
Στις Wednesday 07 April 2010 11:26:29 ο/η Sergey Konoplev έγραψε:
> On 6 April 2010 21:33, Lee Hachadoorian <lee.hachadoorian@gmail.com> 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
Thats definitely worth checking out.
Personally i didn't follow this apprach cause it seemd a little bit more restricting than doing it my way.
However, for this case especially, it looks like it solves a photograph of the original problem of this therad.
Besides, the authors of this fine contrib module are the same known PostgreSQL contributors
of tsearch2, postgresql FTS, intarray (which i heavily use for the tree representation), etc...
>
>
> --
> 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
>
--
Achilleas Mantzios
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: Table Design for Hierarchical Data
In-Reply-To: <201004071134.25176.achill@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox