pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Roberto Mello <rmello@cc.usu.edu>
To: Gautham S. Rao <gautam.rao@tatainfotech.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Hierarchical Queries
Date: Tue, 9 Apr 2002 09:34:00 -0600
Message-ID: <20020409153400.GA6376@cc.usu.edu> (raw)
In-Reply-To: <014b01c1dfc7$155480b0$41057aa3@tatainfotech.com>
References: <014b01c1dfc7$155480b0$41057aa3@tatainfotech.com>

On Tue, Apr 09, 2002 at 06:34:29PM +0530, Gautham S. Rao wrote:
> Hi,
> 
> Can someone tell me how to write a hierarchical query in pgsql. What I want is something like the '...CONNECT BY PRIOR ... START WITH....' clause which is available in Oracle.

There have been lots of messages discussing this topic on this list.
Search the archives and take a look at the "Porting from Oracle PL/SQL"
chapter of the documentation.

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ 
       http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
Ad astra, per ardua nostra.



view thread (9+ messages)

Message-ID: <20020409153400.GA6376@cc.usu.edu>
Permalink:  ../20020409153400.GA6376@cc.usu.edu/
Also on:    postgresql.org/message-id/20020409153400.GA6376@cc.usu.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: rmello@cc.usu.edu, gautam.rao@tatainfotech.com
  Subject: Re: Hierarchical Queries
  In-Reply-To: <20020409153400.GA6376@cc.usu.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox