Derek & Bob escreveu: > I've got a question about table connectby method. Say, we have five elements > which are 1,2,3,4,5. Each of them are the roots in the tree.Instead of using > five connectby methods to generate them all in the table, I assume there is > a element 0, which is the parent of them, in the tree(which is not existed > in the real table). So only one connectby is enough to get them all, and it > works. > This is *not* a bug. How would connectby guess you want to group all of the root elements? Maybe another connectby variant that assumes start_with as an array. A patch would be welcome.
-- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs