Received: from dargolad.esoterica.pt (dargolad.esoterica.pt [195.22.0.27]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0FGkhV15899 for ; Tue, 15 Jan 2002 11:46:44 -0500 (EST) (envelope-from prodrigues@vianetworks.pt) Received: from vianetworks.pt (eol.esoterica.pt [195.22.0.215]) by dargolad.esoterica.pt (8.11.6/8.11.6) with ESMTP id g0FGkh006947; Tue, 15 Jan 2002 16:46:43 GMT Message-ID: <3C445CEE.8040505@vianetworks.pt> Date: Tue, 15 Jan 2002 16:46:38 +0000 From: Paulo Rodrigues Organization: VIA NET.WORKS Portugal User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.4) Gecko/20011019 Netscape6/6.2 X-Accept-Language: en-us, pt MIME-Version: 1.0 To: Wei Weng CC: pgsql-sql@postgresql.org Subject: Re: Hierarchical queries References: <3C4430FF.30803@vianetworks.pt> <20020115114744.494618a7.wweng@kencast.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Archive-Number: 200201/168 X-Sequence-Number: 6254 Hi Wei, An example would be a Bill of Materials; with Oracle I'd do select level, item_id, parent_id, quantity from boms start with parent_id='A' connect by prior parent_id=item_id; This is what I understand for a "tree-like" query. If that's the wrong name for it, it's my mistake, I'm sure. Thanks, Paulo Wei Weng wrote: > What is a "tree-like" queries? Or you mean a query returns you a hierarchy > structure? (Thus tree like) > > On Tue, 15 Jan 2002 13:39:11 +0000 > Paulo Rodrigues wrote: > > >>Hello all, >> >>how do you usually handle hierarchical (tree-like) queries? I'm sure >>someone else needed this already. >> >>Thanks in advance, >>Paulo >> >>-- >>Paulo Rodrigues >>Professional Services / MIS >>prodrigues@vianetworks.pt >> >>VIA NET.WORKS Portugal >>http://www.vianetworks.pt >>local touch global reach >>------------------------- >>http://security.vianetworks.pt/sig/ >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 4: Don't 'kill -9' the postmaster >> >> > > -- Paulo Rodrigues Professional Services / MIS prodrigues@vianetworks.pt VIA NET.WORKS Portugal http://www.vianetworks.pt local touch global reach ------------------------- Sabe quem tem acesso à rede da sua empresa? http://security.vianetworks.pt/sig/