Re: connectby queries

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Chandan_Kumaraiah <Chandan_Kumaraiah(at)satyam(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: connectby queries
Date: 2005-03-28 16:37:01
Message-ID: 20050328163701.GA71083@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Seeber 2005-03-28 19:44:21 Postgres 7.3 migrate to 8.0 date problems.
Previous Message Alvaro Herrera 2005-03-28 14:43:35 Re: Executing Anonymous Blocks