Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 533569FBB43 for ; Wed, 14 Feb 2007 05:22:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 52360-04 for ; Wed, 14 Feb 2007 05:22:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web35815.mail.mud.yahoo.com (web35815.mail.mud.yahoo.com [66.163.179.184]) by postgresql.org (Postfix) with SMTP id 711D49FBB39 for ; Wed, 14 Feb 2007 05:22:24 -0400 (AST) Received: (qmail 26808 invoked by uid 60001); 14 Feb 2007 09:22:23 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=BIcYD444rxnfBC4dIToQE1kAaQfB9k4f9FflRBa58KikargVbEcmfAL37G9rgF8suf2jhOgmIvrRosjtrHNDzle0aWNDQXvFaNAE1e9gLswI8wJ/XmEWvxBGQwcjc7LVMcl7tB8PU92af0W9AGRr9pXWaXo7jiPtCOiA6HqU0Lo=; X-YMail-OSG: PdshrywVM1mvQ_EPy2bNKN6kzg6bZcVnUXY0Qvepm_nHICdPgqijwK_lffdUYKIqCo_BGifOu0grxnP5XNcB3XcaO1vimJCCThWDBtF8DzjRHhB04562K0tThDCFQ9vnEubkz70JW2x0wsc- Received: from [218.248.37.146] by web35815.mail.mud.yahoo.com via HTTP; Wed, 14 Feb 2007 09:22:23 GMT Date: Wed, 14 Feb 2007 09:22:23 +0000 (GMT) From: gayathri jayapal Subject: clarififcation To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1171236851-1171444943=:25377" Content-Transfer-Encoding: 8bit Message-ID: <133614.25377.qm@web35815.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.152 tagged_above=0 required=5 tests=BAYES_50, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_00_10, HTML_MESSAGE X-Spam-Level: **** X-Archive-Number: 200702/790 X-Sequence-Number: 109280 --0-1171236851-1171444943=:25377 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hai, I started working on postgresql, I want to know how to write the " connect by" clause of oracle. My problem is i have a table with id, parent id. In same table i will insert the record with parent id as previous row id. I want fetch the records in the hierarchy. how do i do it. Pls help me. I want to get in touch with developers and then i need to try multi master replication also. Regards, Gayathri Send instant messages to your online friends http://uk.messenger.yahoo.com --0-1171236851-1171444943=:25377 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hai,

I started working on postgresql, I want to know how to write the " connect by" clause of oracle. My problem is i have a table with id, parent id. In same table i will insert the record with parent id as previous row id. I want fetch the records in the hierarchy. how do i do it.

Pls help me. I want to get in touch with developers and then i need to try multi master replication also.

Regards,
Gayathri

Send instant messages to your online friends http://uk.messenger.yahoo.com --0-1171236851-1171444943=:25377--