Re: Categories and Sub Categories (Nested)

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 //

In response to

Browse pgsql-general by date

  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