Re: self referencing tables/ nested sets etc...

From: Rob Hoopman <rob(at)tuna(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: self referencing tables/ nested sets etc...
Date: 2004-03-25 14:38:39
Message-ID: 200403251538.39928.rob@tuna.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you both, I should have known to have look at the contribs first.

On Thursday 25 March 2004 06:37, Joe Conway wrote:
> Shawn Harrison wrote:
> > Forbes. But my own approach is to let the unique id of each object serve
> > as its "key" in the nested set key-chain (which I call its "ancestry"),
> > and separate the ids with path separator, e.g.:
>
> See connectby() in contrib/tablefunc. It produces much the same output
> dynamically.
>
> Joe
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2004-03-25 14:45:40 Re: Adding flexibilty to queries
Previous Message Andrew Dunstan 2004-03-25 14:37:30 Re: subversion vs cvs (Was: Re: linked list rewrite)