Re: celko nested set functions - Mailing list pgsql-sql

From Josh Berkus
Subject Re: celko nested set functions
Date
Msg-id 200210021511.03318.josh@agliodbs.com
Whole thread Raw
In response to celko nested set functions  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-sql
Robert,

> I'm wondering if anyone has written code that enables you to move
> entities between parents in a nested set model. Specifically something
> that can do it without deleting any of the children involved in the
> process.  I looked in the postgresql cookbook which had adding and
> building tree's, but not moving.  I'm hoping to find something
> postgresql specific but if not that's ok. Thanks in advance,

I've been planning on doing this as an article for a while.   I'll send you an
answer off-list because I don't want to publicize it until I can add some
commentary.


--
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: schedule of v7.3
Next
From: Joe Conway
Date:
Subject: Re: split function for pl/pgsql