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

output branches before infinite recursion using connectby()?

From: Zhenchang Xing <xing(at)cs(dot)ualberta(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: output branches before infinite recursion using connectby()?
Date: 2004-09-30 20:43:30
Message-ID: Pine.LNX.4.44.0409301431450.12875-100000@cambria.cs.ualberta.ca (view raw or flat)
Thread:
Lists: pgsql-hackers
hi,

is it possible to output the branches before the detection of infinite 
recursion when using connectby()? My work is about software evolution 
analysis. One of the questions i am interested in is class usage. For 
example, class A uses B, B uses C, C uses D, and finally D uses A. I know 
connectby() can detect infinite recursion, but it does not output 
anything if such recursion is detected. Furthermore, to avoid infinite 
recursion, the depth can be given in advance. But in the real world, I 
cannot know in advance the the depth of such usage. It would be very helpful
if connectby() can output the branches before the detection of infinite 
recursion. Take the above example, output: A uses B, B uses C, C uses D, 
and stop when detecting D uses A.

thanks so much.
zhenchang


Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2004-09-30 20:48:31
Subject: Re: More pgindent bizarreness
Previous:From: Tom LaneDate: 2004-09-30 20:43:17
Subject: Re: Bug in Beta3 with parser?

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