Re: Table Design for Hierarchical Data

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