X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CB442475AFF for ; Mon, 3 Mar 2003 11:57:19 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 44290-08 for ; Mon, 3 Mar 2003 11:57:15 -0500 (EST) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 67881475CB4 for ; Mon, 3 Mar 2003 11:50:20 -0500 (EST) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50] (may be forged)) by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id h23Kv9Is027074; Mon, 3 Mar 2003 18:57:09 -0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id h23Kv92D027070; Mon, 3 Mar 2003 18:57:09 -0200 Date: Mon, 3 Mar 2003 18:57:09 -0200 (GMT+2) From: Achilleus Mantzios To: Rajesh Kumar Mallah Cc: Eric , Subject: Re: Querying Hierarchical Data In-Reply-To: <200303032110.09513.mallah@trade-india.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/76 X-Sequence-Number: 12116 Altho i think the genealogical arrays implementation is solid, fast and intuitive, for doit-yourselfers, i must definately point out the tree module on http://www.sai.msu.su/~megera/postgres/gist/ by the GiST team. On Mon, 3 Mar 2003, Rajesh Kumar Mallah wrote: > > the URL below writes somthing abt what u are looking for. > http://gppl.terminal.ru/index.eng.html > > > > regds > mallah. > > On Monday 03 March 2003 07:57 am, Eric wrote: > > Hi, > > > > How do I access hierarchical data under PostgreSQL? > > Does it have SQL command similar to Oracle's CONNECT BY? > > > > Any help is appreciated > > > > Eric > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > -- > > Regds > Mallah > > ---------------------------------------- > Rajesh Kumar Mallah, > Project Manager (Development) > Infocom Network Limited, New Delhi > phone: +91(11)6152172 (221) (L) ,9811255597 (M) > > Visit http://www.trade-india.com , > India's Leading B2B eMarketplace. > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-210-8981112 fax: +30-210-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr