| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: celko nested set functions |
| Date: | 2002-10-02 22:11:03 |
| Message-ID: | 200210021511.03318.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-10-03 03:14:49 | Re: split function for pl/pgsql |
| Previous Message | Bruce Momjian | 2002-10-02 21:24:08 | Re: schedule of v7.3 |