Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E390C476292 for ; Wed, 2 Oct 2002 15:52:08 -0400 (EDT) Received: from briar.mmrd.com (unknown [208.255.226.182]) by postgresql.org (Postfix) with ESMTP id 7397447611D for ; Wed, 2 Oct 2002 15:52:05 -0400 (EDT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by briar.mmrd.com (8.11.2/8.11.2) with ESMTP id g92KnlF24069 for ; Wed, 2 Oct 2002 16:49:47 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id g92Jq3x19808 for ; Wed, 2 Oct 2002 15:52:03 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id TK2FW9HM; Wed, 2 Oct 2002 15:52:00 -0400 Subject: celko nested set functions From: Robert Treat To: pgsql-sql@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 02 Oct 2002 15:48:01 -0400 Message-Id: <1033588081.17940.8.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/30 X-Sequence-Number: 9748 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, Robert Treat