Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 38751477402 for ; Fri, 4 Oct 2002 09:36:38 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 6FB7A476B01 for ; Fri, 4 Oct 2002 09:25:10 -0400 (EDT) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g94DaCZ24805; Fri, 4 Oct 2002 16:36:12 +0300 Date: Fri, 4 Oct 2002 16:36:12 +0300 (EEST) From: Achilleus Mantzios To: Camila Rocha Cc: pgsql-sql@postgresql.org Subject: Re: rows in order In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/58 X-Sequence-Number: 9776 How do you plan to keep your tree represented?? There are quite a few options for this. Extensive talk has been made in this list. Also search the archives. Basically you can follow - nested trees (pure sql) aproach - Genealogical tree representation approach (either using text to represent the path to the parent (pure sql), or arrays) - The contrib/tree implementation ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr