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.