Re: Categories and Sub Categories (Nested) - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Categories and Sub Categories (Nested)
Date
Msg-id 444757BA.9020704@magproductions.nl
Whole thread Raw
In response to Re: Categories and Sub Categories (Nested)  ("Ian Harding" <iharding@destinydata.com>)
List 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@magproductions.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 //

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Unable to connect to PostgreSQL server
Next
From: Shane Ambler
Date:
Subject: Re: Unable to connect to PostgreSQL server