Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160]) by postgresql.org (Postfix) with ESMTP id 986FC4763FC for ; Tue, 9 Apr 2002 11:33:26 -0400 (EDT) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 16uxdA-0001f8-00; Tue, 09 Apr 2002 09:34:00 -0600 Date: Tue, 9 Apr 2002 09:34:00 -0600 From: Roberto Mello To: "Gautham S. Rao" Cc: pgsql-sql@postgresql.org Subject: Re: Hierarchical Queries Message-ID: <20020409153400.GA6376@cc.usu.edu> References: <014b01c1dfc7$155480b0$41057aa3@tatainfotech.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <014b01c1dfc7$155480b0$41057aa3@tatainfotech.com> User-Agent: Mutt/1.3.28i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Archive-Number: 200204/101 X-Sequence-Number: 7366 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.