X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 85F43D1B8B6 for ; Sun, 4 Apr 2004 08:13:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08505-02 for ; Sun, 4 Apr 2004 05:14:03 -0300 (ADT) Received: from mail.networkprograms.com (unknown [203.190.139.254]) by svr1.postgresql.org (Postfix) with ESMTP id 7F11AD1E9B8 for ; Sun, 4 Apr 2004 05:13:40 -0300 (ADT) Received: from KAMALR ([192.9.203.78]) by mail.networkprograms.com (8.12.9/8.12.9) with SMTP id i348H1bB028241 for ; Sun, 4 Apr 2004 13:47:01 +0530 Message-ID: <02ad01c41a1d$4255a7a0$4ecb09c0@KAMALR> Reply-To: "Kamalraj Singh Madhan" From: "Kamalraj Singh Madhan" To: References: <200404040323.i343Nw3Z002747@gw.tssi.com> Subject: Substitute for this oracle query in postGre Date: Sun, 4 Apr 2004 13:47:24 +0530 MIME-Version: 1.0 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Scanned-By: MIMEDefang 2.40 X-Virus-Scanned: by amavisd-new at postgresql.org Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline X-Archive-Number: 200404/25 X-Sequence-Number: 6325 Hi Friends, Does anybody know the substitute of the oracle function 'connect by prior' in postgre sql. The query is basically being used to get a tree structure of records. The query in oracle is :- select pkmsgid from mstmessage connect by prior pkmsgid = msgparentid start with msgparentid = 1 Kindly suggest. regards Kamal ********************************************************************* Network Programs is a SEI CMM Level 5 Certified Company ******************************************************************** The information contained in this communication (including any attachments) is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. Network Programs (India) Limited is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. *********************************************************************