| From: | Euler Taveira de Oliveira <euler(at)timbira(dot)com> |
|---|---|
| To: | Derek & Bob <yinliangdl(at)163(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4370: connectby method |
| Date: | 2008-08-22 22:41:41 |
| Message-ID: | 48AF40A5.7040007@timbira.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-08-23 01:43:22 | FAQ 1.1 has wrong developer's FAQ address |
| Previous Message | Eric P. Melbardis | 2008-08-22 21:28:59 | Re: BUG #4274: uuid returns duplicate values |