Re: self referencing tables/ nested sets etc... - Mailing list pgsql-general

From Rob Hoopman
Subject Re: self referencing tables/ nested sets etc...
Date
Msg-id 200403251538.39928.rob@tuna.nl
Whole thread Raw
In response to Re: self referencing tables/ nested sets etc...  (Joe Conway <mail@joeconway.com>)
List 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

pgsql-general by date:

Previous
From: Alan Carbutt
Date:
Subject: Re: Adding flexibilty to queries
Next
From: Mike Nolan
Date:
Subject: Re: Adding flexibilty to queries