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: (view raw, whole thread or download thread mbox)
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

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-2017 The PostgreSQL Global Development Group