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

From: Joe Conway <mail(at)joeconway(dot)com>
To: Shawn Harrison <harrison(at)tbc(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: self referencing tables/ nested sets etc...
Date: 2004-03-25 05:37:33
Message-ID: 4062701D.80606@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2004-03-25 05:44:43 Re: 7.4.2 on Solaris 9 - Error
Previous Message Dustin Sallings 2004-03-25 05:25:30 Re: subversion vs cvs (Was: Re: linked list rewrite)