Thread: connectby queries

connectby queries

From
"Chandan_Kumaraiah"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">How do I write hierarchical queries in postgresql, which I would write using ‘connectby’ in
oracle??</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Thanx in adv</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Chandan</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font></div>

Re: connectby queries

From
Michael Fuhr
Date:
On Mon, Mar 28, 2005 at 02:02:32PM +0530, Chandan_Kumaraiah wrote:
>
> How do I write hierarchical queries in postgresql, which I would write
> using 'connectby' in oracle??

The contrib/tablefunc module has a connectby() function -- does it
do what you want?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/