From: Sergey Konoplev <gray.ru@gmail.com>
To: Lee Hachadoorian <lee.hachadoorian@gmail.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Table Design for Hierarchical Data
Date: Wed, 7 Apr 2010 12:26:29 +0400
Message-ID: <w2yc3a7de1f1004070126o74fdebe3y762b67323e888523@mail.gmail.com> (raw)
In-Reply-To: <n2i5ab13581004061033j4ed25734xd0504cb95a1fc092@mail.gmail.com>
References: <n2i5ab13581004061033j4ed25734xd0504cb95a1fc092@mail.gmail.com>
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
--
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
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: gray.ru@gmail.com, lee.hachadoorian@gmail.com
Subject: Re: Table Design for Hierarchical Data
In-Reply-To: <w2yc3a7de1f1004070126o74fdebe3y762b67323e888523@mail.gmail.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