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

From Joe Conway
Subject Re: self referencing tables/ nested sets etc...
Date
Msg-id 4062701D.80606@joeconway.com
Whole thread Raw
In response to Re: self referencing tables/ nested sets etc...  ("Shawn Harrison" <harrison@tbc.net>)
Responses Re: self referencing tables/ nested sets etc...
List pgsql-general
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

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] unicode error and problem
Next
From: Joe Conway
Date:
Subject: Re: 7.4.2 on Solaris 9 - Error