Re: BUG #4370: connectby method - Mailing list pgsql-bugs

From Euler Taveira de Oliveira
Subject Re: BUG #4370: connectby method
Date
Msg-id 48AF40A5.7040007@timbira.com
Whole thread Raw
In response to BUG #4370: connectby method  ("Derek & Bob" <yinliangdl@163.com>)
List pgsql-bugs
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/

pgsql-bugs by date:

Previous
From: "Eric P. Melbardis"
Date:
Subject: Re: BUG #4274: uuid returns duplicate values
Next
From: Alvaro Herrera
Date:
Subject: FAQ 1.1 has wrong developer's FAQ address