Re: rows in order - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: rows in order
Date
Msg-id Pine.LNX.4.44.0210041614570.24754-100000@matrix.gatewaynet.com
Whole thread Raw
In response to rows in order  ("Camila Rocha" <camilarrocha@hotmail.com>)
Responses Re: rows in order
List pgsql-sql
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),
orarrays)
- 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



pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Can Postgres cache a table in memory?
Next
From: Tom Lane
Date:
Subject: Re: please help with converting a view in oracle into postgresql readably code