From: | Alban Hertroys <alban(at)magproductions(dot)nl> |
---|---|
To: | Ian Harding <iharding(at)destinydata(dot)com> |
Cc: | Martin Kuria <martinkuria(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Categories and Sub Categories (Nested) |
Date: | 2006-04-20 09:43:22 |
Message-ID: | 444757BA.9020704@magproductions.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ian Harding wrote:
> You should look up the contrib module ltree which is made for this
> sort of thing. If you reinvent the wheel like this, you will be stuck
> with 2 levels. With ltree you can have as many as you need and add
> more at any time. It lets you query for ancestors and descendants of
> any item at any level.
>
> I highly recommend it.
Ah, one of those modules I still need to investigate. It looks promising.
Can it do networked structures? That'd be kind of hard with an index on
a path when a node can have multiple parent nodes, I figure...
--
Alban Hertroys
alban(at)magproductions(dot)nl
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //
From | Date | Subject | |
---|---|---|---|
Next Message | Shane Ambler | 2006-04-20 09:46:20 | Re: Unable to connect to PostgreSQL server |
Previous Message | news.postgresql.org | 2006-04-20 09:39:03 | Notification EXTRA data |