Re: [GENERAL] self referencing tables/ nested sets etc...

2004-03-26 Thread Shawn Harrison
IL PROTECTED]> To: "Shawn Harrison" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 24, 2004 11:37 PM Subject: Re: [GENERAL] self referencing tables/ nested sets etc... > Shawn Harrison wrote: > > Forbes. But my own approach is to let the unique id of

Re: [GENERAL] self referencing tables/ nested sets etc...

2004-03-25 Thread Manfred Koizar
On Thu, 25 Mar 2004 20:56:35 +0100, Rob Hoopman <[EMAIL PROTECTED]> wrote: >> > It appears that when adding more than 48 sub nodes >> >to any node in the tree, craps out because of an INT8 column overflowing. >> >> AFAICS it doesn't depend on the number of siblings, but it fails when >> the sum of

Re: [GENERAL] self referencing tables/ nested sets etc...

2004-03-25 Thread Rob Hoopman
On Thursday 25 March 2004 12:19, Manfred Koizar wrote: > On Tue, 23 Mar 2004 22:25:17 +0100, Rob Hoopman <[EMAIL PROTECTED]> wrote: > >What solutions are there to storing a wide/shallow self referencing tree > > in a database? > > contrib/ltree (http://www.sai.msu.su/~megera/postgres/gist/ltree/) o