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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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