Re: rows in order - Mailing list pgsql-sql

From Oleg Bartunov
Subject Re: rows in order
Date
Msg-id Pine.GSO.4.44.0210041905370.20942-100000@ra.sai.msu.su
Whole thread Raw
In response to Re: rows in order  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
On Fri, 4 Oct 2002, Achilleus Mantzios wrote:

>
> 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

contrib/ltree !

>
> ==================================================================
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
Regards,    Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83



pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: How slow is distinct - 2nd
Next
From: "Josh Berkus"
Date:
Subject: Re: Can Postgres cache a table in memory?