| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | "Gautham S(dot) Rao" <gautam(dot)rao(at)tatainfotech(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Hierarchical Queries |
| Date: | 2002-04-09 15:34:00 |
| Message-ID: | 20020409153400.GA6376@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Atkins | 2002-04-09 17:08:31 | type conversion? |
| Previous Message | Søren Vainio | 2002-04-09 14:21:43 | Re: Scadinavian characters in regular expressions |