Received: from brelay.tatainfotech.com (unknown [202.54.39.145]) by postgresql.org (Postfix) with ESMTP id 6355E4750F5 for ; Tue, 9 Apr 2002 08:47:24 -0400 (EDT) Received: from blrmail.in.tatainfotech.com (IDENT:root@localhost [127.0.0.1]) by brelay.tatainfotech.com (8.11.0/8.11.0) with ESMTP id g39CmV615393 for ; Tue, 9 Apr 2002 18:18:35 +0530 Received: from dsspntw34 ([163.122.5.65]) by blrmail.in.tatainfotech.com (8.9.3/8.9.3) with SMTP id SAA09087 for ; Tue, 9 Apr 2002 18:19:13 +0530 Message-ID: <014b01c1dfc7$155480b0$41057aa3@tatainfotech.com> From: "Gautham S. Rao" To: Subject: Hierarchical Queries Date: Tue, 9 Apr 2002 18:34:29 +0530 Organization: Tata Infotech Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0148_01C1DFF5.2EF75FF0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-Mimeole: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/97 X-Sequence-Number: 7362 This is a multi-part message in MIME format. ------=_NextPart_000_0148_01C1DFF5.2EF75FF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 whic= h is available in Oracle. Regards, Gautham. ------=_NextPart_000_0148_01C1DFF5.2EF75FF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
Can someone tell me how to write a hierarc= hical=20 query in pgsql. What I want is something like the '...CONNECT BY PRIOR ... = START=20 WITH....' clause which is available in Oracle.
 
Regards,
Gautham.
 
------=_NextPart_000_0148_01C1DFF5.2EF75FF0--