Re: [PERFORM] Nested Sets WAS: column size too large, is this a bug?

2004-03-30 Thread Josh Berkus
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

Re: [PERFORM] Nested Sets WAS: column size too large, is this a bug?

2004-03-30 Thread Robert Treat
On Tuesday 30 March 2004 11:38, Josh Berkus wrote: 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

Re: [PERFORM] Nested Sets WAS: column size too large, is this a bug?

2004-03-30 Thread Josh Berkus
Robert, http://archives.postgresql.org/pgsql-sql/2002-11/msg00355.php Seemed to work though someone else had posted yet another version after ours... and in fact the one posted is not exactly what I use now either :-) Hmmm ... I'd want to do a *lot* of testing before I trusted that