Skip site navigation (1) Skip section navigation (2)

Re: BUG #4370: connectby method

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 (view raw or flat)
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/

In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2008-08-23 01:43:22
Subject: FAQ 1.1 has wrong developer's FAQ address
Previous:From: Eric P. MelbardisDate: 2008-08-22 21:28:59
Subject: Re: BUG #4274: uuid returns duplicate values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group