Postgres Pro
Downloads
Home   >   mailing lists

Re: connectby queries - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: connectby queries
Date
Msg-id 20050328163701.GA71083@winnie.fuhr.org
Whole thread Raw
In response to connectby queries  ("Chandan_Kumaraiah" <Chandan_Kumaraiah@satyam.com>)
List pgsql-sql
Tree view 
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/

pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Executing Anonymous Blocks
Next
From: Thomas Seeber
Date:
Subject: Postgres 7.3 migrate to 8.0 date problems.