Robert, > 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 another.
I have to admit to failing to follow -SQL over the last few months. This list and Hackers are pretty much the only ones I read all of. Maybe I should get back on -SQL and we can compare move_tree functions :-) Did yours use a temp table, or some other means? -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
