On Sunday 28 March 2004 14:25, Josh Berkus wrote:
> Andrew,
> > I used to use the connect-by patch, but have since rewritten everything
> > to use a nested set model.
> Cool!   You're probably the only person I know other than me using nested
> sets in a production environment.

You cut me deep there Josh, real deep.  :-)

If you search the pgsql-sql archives you'll find some helpful threads on using 
nested sets in PostgreSQL, one in particular I  was involved with was a 
generic "move_tree" function that enabled moving a node from one branch to 

Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to